OWB - Joiner operator

Card Puncher Data Processing

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.

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.

Joiner Operator

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

Reference





Discover More
Card Puncher Data Processing
OWB - Operators

The operators are used in a mapping to create a process and have several types : Source/Target Operators: These operators represent Oracle Database objects in the mapping. It also contains Flat File...
Card Puncher Data Processing
Oracle Warehouse Builder

Owb Documentation - Understanding Data Quality Management White...
Owb Less 1
Owb - Log (Diagnostic)

This page concerns the debugging of the owb software, not of a mapping. To find a problem in your mapping, see this page: . Warehouse Builder Repository Assistant: OWB_ORACLE_HOME\owb\UnifiedRepos\log_.log...



Share this page:
Follow us:
Task Runner