OWB - Joiner operator

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 :

• inner/equi joins,
• outer joins,
• and non-equijoins.

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.

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.

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 */

• Oracle Documentation