Add a Joiner transformation to the mapping and configure dynamic ports to receive any new and changed columns from the Read transformation. Define a join condition to join the two source tables CUSTOMER and ORDERS.
Add a Joiner transformation Join_CustomerOrders to the mapping.
Create dynamic ports in the Joiner transformation:
From the Read_Customer transformation, drag the All Ports group to the Master group in the Joiner transformation.
The Developer tool creates a dynamic port From_Read_CUSTOMER in the Master group and the Output group.
From the Read_Orders transformation, drag the All Ports group to the Detail group in the Joiner transformation.
The Developer tool creates a dynamic port From_Read_ORDERS in the Detail group and the Output group.
The dynamic ports include all ports from the corresponding Read transformations as generated ports.
The following image shows the All Ports groups from the Read transformations linked to the two dynamic ports in the Joiner transformation:
In the
Properties
view, click the
Join
tab.
Click the
New
button, and define the join condition as C_CUSTKEY = O_CUSTKEY_DTL.