ODI snippets: Generating ANSI compliant Joins in Oracle

Published on September 27, 2012

Get our e-books Discover the Oracle Data Integrator 11g Repository Data Model and Oracle Data Integrator Snippets and Recipes
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’.