Union Transformation in Informatica

The Union Transformation in Informatica combines data from multiple sources (excel files, flat files, etc.) or multiple SQL tables and produces one output to store in the target table. It is an active transformation, and it is similar to the SQL Union All. The Union Transformation in Informatica is very useful in real-time. For example, … Read more