Join Conditions are not Picked up by ODI 12c when Executing the Code
(Doc ID 2379816.1)
Last updated on FEBRUARY 27, 2019
Applies to:Oracle Data Integrator - Version 22.214.171.124.0 and later
Information in this document applies to any platform.
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.
This behavior can be observed in ODI Studio as follows:
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document