Oracle Data Integrator (ODI) "getFrom()" Method Generates Incorrect SQL Outer Join Clauses
(Doc ID 459925.1)
Last updated on JUNE 16, 2022
Applies to:Oracle Data Integrator - Version 4.1.01.07 to 10.1.3.4.4 [Release 4.1.01 to 10gR3]
Information in this document applies to any platform.
In certain Oracle Data Integrator (ODI) Integration Interfaces - and depending on Technology - when the SQL is generated from outer join operations, unwanted supplementary table aliases are inserted into the SQL Join clause instruction.
This renders the SQL Join clause instruction inoperative and inhibits the use of the Integration Interface.
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