Making use of ODI Flexfields to meet requirements

Uli Bethke Oracle Data Integrator (ODI)

What are ODI Flexfields? In ODI you can create user-defined fields on certain objects. You can think of these fields as additional attributes for certain objects. At design time you populate these attributes with values that are then used at runtime, e.g. by a Knowledge Module. There are various Flexfields defined out of the box for very specific requirements, e.g. ...

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 ...

How to query a whole schema or even database?! This tip will save you hours and hours of boring work.

Uli Bethke Oracle Data Integrator (ODI)

I really like this tip especially its simplicity. It has saved me hours and hours of mind numbing work in the past. The use case Imagine the following situation. You are tasked to complete a source to target map. With the help of various source system SMEs, legacy data models, and the data dictionary of the source database you have ...

Best practice of organizing interfaces and data stores into projects and models in ODI

Uli Bethke Oracle Data Integrator (ODI)

Have you ever wondered what the best way is to structure your objects in ODI into projects? Look no further. I will outline what works well for an Enterprise Data Warehouse. Let’s assume you follow the Oracle reference architecture for data warehousing and you have a couple of source systems, a staging area, a foundation layer (core data warehouse), and ...

ODI snippets: Generating ANSI compliant Joins in Oracle

Uli Bethke Oracle Data Integrator (ODI)

It's great to see that the Oracle technology in ODI 11g now supports ANSI compliant JOINS. However, when you create an interface that joins one or more tables this is not the default option. To enable this you need to click on the Join icon between your tables and select checkbox 'Use Ordered Join Syntax'.