OWB 11.2 Generates Cartesian Product / Cross Join Instead of Full Outer Join When using Non ANSI SQL Syntax
(Doc ID 1319572.1)
Last updated on FEBRUARY 04, 2019
Applies to:
Oracle Warehouse Builder - Version 11.2.0.1 to 11.2.0.2 [Release 11.2]Information in this document applies to any platform.
Symptoms
An 11.2 Mapping with a JOIN condition:
"SOURCE_TABLE1.COLUMN1(+)=SOURCE_TABLE.COLUMN1(+)",
generates Cartesian Product when the ANSI SQL syntax property of the mapping is set to FALSE. (WHERE CLAUSE MISSING)
The generated code looks like this :
1. With ANSI SQL syntax property of mapping is set to FALSE
Changes
Upgrade from OWB 10.2 to 11.2.
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 |