Database Reference
In-Depth Information
Full join
When you define a full join, Integration Service allows all the matching and nonmatching
records from both the master and detail source.
The result of the full join for the previously mentioned data is as follows:
EMPLOYEE_ID,AGE,SAL
101,20,1000
102,30,NULL
103,20,4000
105,NULL,2000
106,NULL,4000
110,NULL,5000
Master outer join
When you define a master outer join, Integration Service allows all matching records from
both the master and detail source and also allows all other records from the details table.
The result of the master outer join for the previously mentioned data is as follows:
EMPLOYEE_ID,AGE,SAL
101,20,1000
103,20,4000
105,NULL,2000
106,NULL,4000
110,NULL,5000
Detail outer join
We you define a detail outer join, Integration Service allows all matching records from
both the master and detail source and also allows all other records from the master table.
The result of the detail outer join for the previously mentioned data is as follows:
EMPLOYEE_ID,AGE,SAL
101,20,1000
102,30,NULL
103,20,4000
