Hello Friends,
Here, Today will discuss union transformation in infomratica. Union transformation in active transformation and used to merge records from two or more sources.
The data type,precision and size should be exactly match with other source. The union transformation works as UNION ALL as of in SQL . i.e. it gives you all the records. It does not remove duplicate record.
Here, We will discuss how to use UNION transformation and how to filter out duplicate records using sorter transformation as explain in below video.
