Support for Subqueries in Join Operator

The JOIN operator in OWB now supports several new behaviors related to the use of subqueries in joins:

Specifying subqueries using EXISTS, NOT EXISTS, IN, and NOT IN.
Specifying outer joins using the input role instead of the + (plus) sign.
Generating ANSI SQL syntax for all join types instead of only outer joins.

More flexible handling for JOIN operations improves developer productivity and makes possible more flexible data transformations.

See Also:

Joiner Operator in Oracle Warehouse Builder Data Modeling, ETL, and Data Quality Guide
"Creating and Editing Joins" in Oracle Warehouse Builder Sources and Targets Guide