Outer Join Not Propagated to Filters in ODI 188.8.131.52.0 Mappings
(Doc ID 2344824.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle Data Integrator - Version 184.108.40.206.0 and later
Information in this document applies to any platform.
Even though the steps from <Document 1992737.1> (to properly use outer joins) have been followed, the Create View generated code is missing the Join+Filter, (+).
- Create a Mapping with an Outer Join and Filter followed by inner join.
- Go to ODI Studio > Topology -> Technology -> Oracle -> SQL -> "Not Ordered" -> "Location Clause"
- Select "After Join for Column and Filter / Splitter" instead of "After Column Join for Only" (default for ODI 12.1.3)
- Observe that the generated code (for the filter) is missing (+)= and has = instead
The mapping in question has a filter using outer joins followed by inner joins.
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