Creating a Union Transformation
You can create a reusable or non-reusable Union transformation.
Creating a Reusable Union Transformation
Create a reusable Union transformation to use in multiple mappings or mapplets.
1. Select a project or folder in the Object Explorer view.
2. Click File > New > Transformation.
The New dialog box appears.
3. Select the Union transformation.
4. Click Next.
5. Enter a name for the transformation.
6. Click Finish.
The transformation appears in the editor.
7. Click the New button to add a port to the transformation.
8. Edit the port to set the name, datatype, and precision.
9. Select the Groups view.
10. Click the New button to add an input group.
11. Click the Advanced view and edit the transformation properties.
Creating a Non-Reusable Union Transformation
Create a non-reusable Union transformation in a mapping or mapplet.
1. In a mapping or mapplet, drag a Union transformation from the Transformation palette to the editor.
The transformation appears in the editor.
2. On the General tab, edit the transformation name and the description.
3. Select all the ports from the upstream transformation and drag them to the Union transformation. The ports appear as ports in an input group and output group of the Union transformation.
4. Click New on the Groups tab in the Properties view to add an input group.
Another input group appears which has similar ports as the existing input group.
5. Select the ports in the output group of the Union transformation and drag them to the downstream transformation in the mapping.