Database Reference
In-Depth Information
Join type
The Joiner transformation matches the data based on the join type defined. Similar to SQL,
Joiner transformation use the join type to join the data. Let's discuss the join type in detail
by taking the following example. We have two sources, the master source as
EMPLOYEE_TABLE
and the detail source as
EMPLOYEE_FILE
:
EMPLOYEE_TABLE (Master Source - Oracle`)
EMPLOYEE_ID,AGE
101,20
102,30
103,20
EMPLOYEE_FILE (Detail Source - Flat File)
EMPLOYEE_ID,SAL
101,1000
103,4000
105,2000
106,4000
110,5000
As you can see, we have created a table with fewer records as the master source to enhance
performance. To assign the join type, double-click on the Joiner transformation and click
on the
Properties
tab. Select the join type out of the four types from the drop-down list, as
shown in the following screenshot:
