ODI Snippets: What is the Optimization Context in ODI?

Published on October 30, 2012

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes
There are a lot of confusing messages out there on what the Optimization Context in ODI is used for.

This is the setting I am talking about

Is it a runtime setting??

First of all, this is not a runtime or execution context setting. It is only used at design time in ODI Studio.
If you execute an interface in your Test context with the Optimization Context set to Development it will still execute in Test.

It is a design Time Setting!

So what is the Optimization Context used for? ODI uses the Optimization Context to validate your Interface at design time. This means it will validate your filters,functions etc. against the environment set in your Optimization Context.
You can easily try this out.
[list_square] [li]Set your Optimization Context to Development[/li] [li]Go to your source table, right click, and select Data…[/li] [li]This will display the Data in the source table in your Development environment[/li][li]Now change the Optimization Context to Test.[/li] [li]Go back to your source table and select Data… again[/li][li]This will now display the data in your test environment[/li][/list_square]

What is this useful for?

Personally I can’t really think of anything, but let me know if you are using this feature.