Join Conditions are not Picked up by ODI 12c when Executing the Code
Last updated on APRIL 09, 2018
Applies to:
Oracle Data Integrator - Version 12.1.2.0.0 and laterInformation in this document applies to any platform.
Symptoms
After having upgraded from Oracle Data Integrator (ODI) 11g to 12c, Mappings containing a combination of outer Joins and full Joins lose the full Join block when executed: the full Join is not generated in the WHERE clause of IKM "Insert flow into I$ table" task.
Note that the behavior is observed when ANSI with non-ANSI Joins are combined, as well when all the Joins use ANSI, or all Joins use non-ANSI.
This behavior can be observed in ODI Studio as follows:
Cause
Sign In with your My Oracle Support account |
|
Don't have a My Oracle Support account? Click to get started |
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms