ODI Snippets: What is the Optimization Context in ODI?

Uli Bethke Oracle Data Integrator (ODI)

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.

About the author

Uli Bethke LinkedIn Profile

Uli has 18 years’ hands on experience as a consultant, architect, and manager in the data industry. He frequently speaks at conferences. Uli has architected and delivered data warehouses in Europe, North America, and South East Asia. He is a traveler between the worlds of traditional data warehousing and big data technologies.

Uli is a regular contributor to blogs and books, holds an Oracle ACE award, and chairs the the Hadoop User Group Ireland. He is also a co-founder and VP of the Irish chapter of DAMA, a non for profit global data management organization. He has co-founded the Irish Oracle Big Data User Group.