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.
Symptoms
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.
Changes
Cause
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
Symptoms |
Changes |
Cause |
Solution |
References |