ODI snippets: Query to retrieve source and target columns in an interface

Uli Bethke Oracle Data Integrator (ODI)

The following query can be used to retrieve the source columns/tables and target columns/tables for interfaces in a specified project NOTE: BELOW QUERY IS VALID FOR ODI 10g ONLY!!! ODI 11g has introduced the concept of data sets, which invalidates below query.

In order to master scripting in ODI I recommend the following books. Java BeanShell Scripting in Java: ...