While joining Source Data of heterogeneous sources as well as to join flat files we will use the Joiner transformation. Use the Joiner transformation when we need to join the following types of sources:
* Join data from different Relational Databases.
* Join data from different Flat Files.
* Join relational sources and flat files.