Why union Transformation is Active?

356 Views Asked by At

Union Transformation is used to combine or merge multiple sources having same structure and data types. if I combine 2 sources one having 10 records and another having 10 records and the output is 20. so here input and output record is same. then why should we call Union is Active. need a example for this

1

There are 1 best solutions below

4
On

Because if you consider the path from a single source to a single target then a UNION transformation between them can/will change the number of rows