OWB - Joiner operator

> Data Integration Tool (ETL/ELT) > Oracle Warehouse Builder

1 - About

The Joiner operator joins multiple row sets from different sources with different cardinalities, and produces a single output row set. The Joiner operator results in a WHERE clause in the generated SQL query. A Joiner can have unlimited number of input groups but only one output group.

You can use the Joiner operator to define a join condition :

You can also create self joins by using a filter operator.

You use the Joiner operator to join multiple row sets from different sources and produce a single output row set.

It's the equivalent in Sql to this statement :

SELECT * FROM
   TableA,
   TableB
WHERE
   TableA.id = TableB.id

where

TableA.id = TableB.id

is the join condition that you define in the join operator.

Advertising

3 - Join condition

You can change the join condition (TableA.id = TableB.id) in the operator properties. Click in the operator bar on the Joiner text, in the left side, you can then change this value.

You can add comments in condition than you don't use SQL statement such as AND … in it.

INOUTGRP1.ATTR_GROUP_ID = 169 
/* the same filter than
ego_attr_groups_v.attr_group_type = CS_SR_CONTEXT en 
ego_attr_groups_v.attr_group_name = XXGBR_KS_VORDERINGEN */

Do not use the join condition to:

  • include aggregation functions
  • add a filter

use instead respectively a aggregate operator and a filter operator

4 - Reference