ODI Snippets: What is the Optimization Context in ODI?
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.
Uli Bethke
Uli has been rocking the data world since 2001. As the Co-founder of Sonra, the data liberation company, he’s on a mission to set data free. Uli doesn’t just talk the talk—he writes the books, leads the communities, and takes the stage as a conference speaker.
Any questions or comments for Uli? Connect with him on LinkedIn.
Follow Uli Bethke: 
