What is Union Transformation ??
- A Union transformation has multiple input groups and one output group.
- Union transformation. equivalent to UNION ALL in SQL
- Union transformation does not remove duplicate rows
- Output and input ports can be created manually or passed from another transformation
- Cannot use a Sequence Generator or Update Strategy transformation upstream from a Union transformation.
Components
of Union Transformation
- Transformation tab: To rename the transformation and give a description.
- Properties tab: You can specify the tracing level.
- Groups tab: For creating and removing groups
- Group Ports tab: For creating and removing ports of groups.
Union Transformation |
Things to Remember
- Number of ports in the entire input group should be the same. If you connect all ports in one input group, but do not connect a port in another input group, the Integration Service passes NULLs to the unconnected port.
- When you add a Union transformation to a mapping, you must verify that you connect the same ports in all input groups. If you connect all ports in one input group, but do not connect a port in another input group, the Integration Service passes NULLs to the unconnected port.
No comments:
Post a Comment