August 2017
Beginner to intermediate
426 pages
9h 36m
English
When you define a Detail Outer join, Integration service allows all matching records from both the Master and Detail sources and also allow all other records from the Master table.
The result of the Detail Outer join for the aforementioned data is shown here:
EMPLOYEE_ID,AGE,SAL 101,20,1000 102,30,NULL 103,20,4000
With this, you have learned about the various options available in Joiner transformation.
Read now
Unlock full access