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
Union Transformation is active
Questions by tejeswari548
Related Answered Questions
Related Open Questions