Joiner Transformation – Normal Join

Joiner Transformation – Normal Join

Let’s create a Mapping with a Joiner Transformation – Normal Join. We are going to join two tables JOB_ID1 & JOB_ID2 and create a target with the ports from two tables.

Normal Join

With a normal join, the Integration Service discards all rows of data from the master and detail source that do not match, based on the condition. This will load only the matched records to target table. 

Joiner Transformation - Normal Join
This is the Master Table (JOB_ID2) – We have 6 records in it. For an unsorted joiner transformation, to get optimal performance, designate the source with the fewer rows as the Master source
Joiner Transformation - Normal Join
This is the Detail table (JOB_ID1). We have 7 records in it.
Joiner Transformation - Normal Join
Created a mapping with Joiner Transformation, Join both the Master & Detail table using JOB ID and load to target table (Normal Join). Output ports are ob_ID, Title & Max_Salary from Master Table & Min_Salary from Detail Table.
Joiner Transformation - Normal Join
Here we can change the Master & Detail table if needed.
Joiner Transformation - Normal Join
Joiner Properties – Join Type is Normal – Everything else is default values.
Joiner Transformation - Normal Join
Here we are matching JOB_ID from both Master & Detail tables
Joiner Transformation - Normal Join
Created a workflow and ran the session, See the session log, Only 4 records got loaded to target.
Joiner Transformation - Normal Join
See the target table, We have only the matched records from Master & the Detail table.

https://youtu.be/Lp93xpHPrMw