JOINER TRANSFORMATION Joiner Transformation is an Active and Connected transformation. The purpose of joiner transformation is to join two heterogeneous sources like two tables from two different databases or one table and one flat file or two flat files. The Joiner transformation joints two sources based on conditions that include one or more pair of columns between the sources. In the two input source pipelines, one is considered as Master source and another one as Detail source, mostly prefer the input source pipeline which has less number of records or duplicate values as Master pipeline. The joiner transformation supports the following four types of joins. Normal Join Master Outer Join Details Outer Join Full Outer Join We will learn about each join type with an example. Let consider the following department and employee tables as the source pipelines. Table Name: DEPARTMENT DEPART_Id DEPART_Name ----------...