Describe the scenarios where we go for Joiner transformation instead of Source Qualifier transformation.

Ans. 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.