jignesh

• Jan 2nd, 2015

 

No doubt union transformation will give you the result as a passive transformation with same number of records,But row number of the records will get changed in output result set.....eg we have table A with record having id as 1 and we are also having table B with same record id as 1. Now when we apply union transformation on both table it will give both records but row number of second tables record will get changed so its an active transformation.....i hope it will help you