Types of Transformations in Informatica

Types of Transformations in Informatica

In Informatica, Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target.
Transformations are of two types: Active and Passive.

Active Transformation
An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.
The following are the list of active transformations used for processing the data
• Source quilter transformation
• Filter transformation
• Ruler transformation
• Rank Transformation
• Sorter transformation
• Joiner transformation
• Union Transformation
• Aggregator Transformation
• Transaction control transformation
• Normalize transformation
• Update strategy transformation
• SQL Transformation

Passive Transformation
A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.
Transformations can be Connected or Unconnected. The no of rows entering the transformation is same as no of rows exist the transformation. It doesn’t effect the no of rows
The following are the list of passive transformations used for processing data.
• Expression transformation
• Sequence generated transformation
• Stored procedure transformation
• Look up transformation
• XML source qualifier transformation
• SQL Transformation

Portland types of ports
A port represent column of a table (or)file. There are two basic type of ports.

Input port:-
A port which can receive the data is know as input port which is represented as :”I”

Output Port:-
A port which can provide the data is know as output port which is represented as “o”.

Connected Transformation
Connected transformation is connected to other transformations or directly to target table in the mapping.
A transformation which is part of mapping data flow direction is known as connected transformation. It is connected the source and connected to the target. All active and passive transformation can be refined as connected transformation. A connected transformation can receive multiple input ports, can provide the multiple output ports.

UnConnected Transformation
An unconnected transformation is not connected to other transformations in the mapping. It is called within another transformation, and returns a value to that transformation.
A transformation which is not part of mapping data flow direction is known as unconnected transformations. It is nether connected to source nor connected to the target. An unconnected transformation can receive the multiple input ports, but provides “single output port”.
The following transformations can be defined as unconnected
Stored procedure transformation
Lookup transformation

319 (1)

Following are the list of Transformations available in Informatica:
• Aggregator Transformation
• Expression Transformation
• Filter Transformation
• Joiner Transformation
• Lookup Transformation
• Normalizer Transformation
• Rank Transformation
• Router Transformation
• Sequence Generator Transformation
• Stored Procedure Transformation
• Sorter Transformation
• Update Strategy Transformation
• XML Source Qualifier Transformation
• Advanced External Procedure Transformation
• External Transformation
In the following pages, we will understand all the above Informatica Transformations and their significances in the ETL process in detail.

%d bloggers like this: