Question { 18349 }

How Union Transformation is an Active Trans?

Answer

The simple ligic of Union is that, It capture all the
unique recorde from bothe the source.
suppose if you have 10 records in table A and 10 records in
table B, in which 3 records are same in both the tables.
Then after using the Union transformation you will get 17
records, as the rescords which are getting duplicated will
not be in the output.