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. 

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
This is the Detail table (JOB_ID1). We have 7 records in it.
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.
Here we can change the Master & Detail table if needed.
Joiner Properties – Join Type is Normal – Everything else is default values.
Here we are matching JOB_ID from both Master & Detail tables
Created a workflow and ran the session, See the session log, Only 4 records got loaded to target.
See the target table, We have only the matched records from Master & the Detail table.

https://youtu.be/Lp93xpHPrMw 

Related Posts: