etlcorner: Union Transformation in Informatica with Example

Union Transformation in Informatica , is a connected and active transformation which let you to merge data from multiple pipelines or pipeline branches into one pipeline branch. Union Transformation merges data of similar source based on UNION ALL SQL statement.

Business scenarios of Union Transformation in Informatica

As name predict , Union transformation is used to merge data from multiple pipelines into single one.

Is Union Transformation Active or Passive ?

Union Transformation is a Active transformation as it combines two or more data streams into one. Although no of rows from multiple input and Output is same, but order in which these row are coming to output can change.

Is Union Transformation Connected or Unconnected ?

Union Transformation is a Connected Transformation.

How Union Transformation work ?

The Integration Service processes all input groups in parallel. It reads sources connected to the Union transformation and pushes blocks of data into the input groups of the transformation. The Union transformation processes the blocks of data based on the order it receives the blocks from the Integration Service irrespective.

Configuring Union Transformation Properties:

Modify the Union Transformation properties by clicking on the Properties tab.

Check here for filter transformation example in informatica

How to use Union transformation in Informatica:

Use the following procedure to create an Union transformation in Informatica mapping.

Steps to create an Union transformation:

In the Mapping Designer, open a Mapping.
Click Transformation > Create. Select Union transformation.

You can also select Transformation by clicking function button on Informatica Designer

Enter a name and click Done.
You can create ports in Union transformation by selecting and dragging it from input transformation to Union transformation.You can manually create input ports on the Group Ports tab by double clicking on it.

Union Transformation step 3
Double-click the title bar of the Union transformation to open the transformation
Click the Groups tab, and then click the Add button to create a user-defined group.The Designer assigns a default name for each group but they can be renamed
Click the Transformation tab and configure transformation properties. ( change Tracing Level as per your need)
Click OK.
Connect group output ports of Union Transformation to other transformation or target

Example of Union Transformation:

Check here for Union transformation example in informatica

Incoming search Terms :

example of union transformation in informatica
union transformation properties in informatica
union transformation in informatica is union all

etlcorner

Sunday, January 10, 2016

Union Transformation in Informatica with Example