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 184.108.40.206 to 220.127.116.11 [Release 11.2]
Information in this document applies to any platform.
An 11.2 Mapping with a JOIN condition:
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
Upgrade from OWB 10.2 to 11.2.
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