Mapping Architect for Visio Guide

10.5.7
- 10.5.6
- 10.5
- 10.4.0

Back Next

Union Transformation

Use the Union transformation to merge data from multiple pipelines or pipeline branches into one pipeline branch. It merges data from multiple sources similar to the UNION ALL SQL statement to combine the results from two or more SQL statements.

The following table describes the required properties for the Union transformation:

Transformation Property	Description
Transformation Name	Name of the transformation.
Module Identifier	Name of the module.
Function Identifier	Name of the procedure in the module.
Transformation Scope	Indicates how the Integration Service applies the transformation logic to incoming data.
Generate Transaction	Indicates if the Union transformation can generate transactions.
Output Is Repeatable	Indicates if the order of the output data is consistent between session runs.
Group Name	Creates multiple input groups and multiple output groups in a transformation.
Group Ports	Creates and deletes ports for input groups and output groups. When you create a port, PowerCenter adds it below the currently selected row or group.

Rename Saved Search

Table of Contents

Mapping Architect for Visio Guide

Mapping Architect for Visio Guide

Union Transformation

Union Transformation