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.
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.