PDI Tutorials - Merging Two Tables from different servers

Lets have a look at the join function provided by the pdi.

Step 1: Drag the table inputs and give the DB credentials.

Step 2: First of all , for merging we need the output from DB is to be sorted because its mandatory for Merging in PDI . Otherwise, the data might be wrong on the continuous rows.

Step 3: Then drag the  Merge Join  find under Joins tab in left side .

Step 4: Double click on Merge join icon and give the first step & second step respectively. Then , press the Get Fields button to get all the fields from the step.

Step 5: Then remove the non key fields from the list and give OK.

Step 6: In order to check the process, press Fn+F10. Preview will be shown.

Find the example screen above.

Thanks,
Dilip