Joiner Transformation

The Joiner transformation is used to join source data from two related heterogeneous sources that has placed in different locations. User can join data from the same source also. The use Joiner transformation sources should have at least one matching column. The Joiner transformation uses a condition that matches one or more pairs of columns between the two sources.

1. Joiner Transformation is a connected and active transformation.

2. Joiner transformation is used to join the source data from two heterogeneous sources residing in different locations or file systems.

3. Joiner Transformation can also join data from same sources.

4. Number of joiners = Number of source -1

The joiner Transformation supports following types of Joins.

Normal Join: (In this join only the matching record of both the tables return from both the sources as output)

Normal Join is equivalent to EQUI JOIN.

Master Outer Join: (In this join all the records from the details source table and only matching records of master table returns as output) Master Outer Join is equivalent to EQUI JOIN with remaining rows from detail table/source.

Detail Outer Join: (In this join only matching records returns from the details source table and all the records from master source table are returned as output)

Detail Outer Join is equivalent to EQUI JOIN with remaining rows from master table/source.

Full Outer Join: (In this join all the records from master and details tables are returned as output)

Full Outer Join is equivalent to EQUI JOIN with Remaining rows form both tables/sources.