Database Reference
In-Depth Information
Normal join
When you define a normal join, Integration Service allows only matching records from
both the master and detail source and discards all other records.
For the preceding scenario, we will set the join condition as
EMPLOYEE_ID =
EMPLOYEE_ID
.
The result of the normal join for the previously-mentioned data is as follows:
EMPLOYEE_ID,AGE,SAL
101,20,1000
103,20,4000
All nonmatching records with a normal join will get rejected.
