| Union transformation is a active transformation. |
| Merges data from different databases or flat files. |
| Similar to the UNION ALL statement, the Union transformation does not remove duplicate rows. |
| You can connect heterogeneous sources to a Union transformation. |
| |
| NOTE:: |
| |
| All input groups and the output group must have matching ports. The precision, datatype, and scale must be identical across all groups. |
| |