How to Join multiple tables without Joiner Transformation
Lets see one scenario, how to join two tables without using Joiner Transformation. This can be achieved by just using Source Qualifier – ‘User Defined Join’ property. Here we are going to join Two tables (EMPLOYEE & JOBS) and create a target table with columns from both the tables.
We are done. Joined two tables without joiner transformation. If you have more number of tables to join, always prefer to go with Joiner transformation which will support cache and will give performance advantages over Source Qualifier.