How is the union transformation active transformattion

         Active Transformation: the transformation that change the no. of   rows in the Target.
            Source (100 rows) ---> Active Transformation ---> Target (< or > 100 rows)Passive Transformation: the transformation that does not change the
            no. of rows in the Target.
            Source (100 rows) ---> Passive Transformation ---> Target (100 rows)
            Union Transformation: in Union Transformation we may combine the  data from two (or) more sources. Assume Table-1 contains '10' rows   and Table-2 contains '20' rows. If we combine the rows of Table-1  and Table-2 we will get a total of '30' rows in the Target. So it is  definetly an Active Transformation.

What is a Union Transformation?

Ans. The Union transformation is an Active, Connected non-blocking multiple input group transformation use to merge data from multiple pipelines or sources into one pipeline branch. Similar to the UNION ALL SQL statement, the Union transformation does not remove duplicate rows.

What are the restrictions of Union Transformation?

• All input groups and the output group must have matching ports. The precision, datatype, and scale must be identical across all groups.
• We can create multiple input groups, but only one default output group.
• The Union transformation does not remove duplicate rows.
• We cannot use a Sequence Generator or Update Strategy transformation upstream from a Union transformation.
• The Union transformation does not generate transactions.