Informatica Transformations

Informatica Transformations are repository Objects that are used to perform aggregations, sorting, merging, modifying, distributing, etc., while passing data through them.

The Informatica Power Center Designer provides a set of transformations that perform specific functions. For example, the Sorter transformation will sort the input fields based on a specified field.

Types of Transformations in Informatica

An Informatica transformation is a part of Mapping, which transforms or modifies the data as per the selected transformation. This section covers the list of available ones with practical examples.

Informatica transformations can divide into two types: Active or Passive. We can further divide them based on the connectivity in mapping: Connected and Unconnected Transformations.

Active Transformations in Informatica

An active type of transformation in Informatica can change the number of rows that pass through it. For example, if the input rows do not meet the specified expression, then those rows will not move to the target.

Passive Transformations in Informatica

The Informatica passive transformation does not change the number of rows passing through it.

Connected Transformations

Within a Mapping, if a transformation is connected to another or connected directly to the target table, it is called Connected.

All the active and passive can call connected transformations in Informatica, and they can receive / or provide multiple input ports.

Unconnected Transformations

Within the Mappings, if the Informatica transformation does not connect to others, we can call it Unconnected. It means it is neither connected to Source nor the target.

Unconnected Lookup is the best example of Informatica Unconnected.

Informatica Transformations List

Before we get into the list of transformations and their definitions, let me open my Power Center Designer to display the available list in mappings:

Informatica Transformations 1

and few more

Few more Transformations 2

The following is a list of Informatica transformations that are available to transform data. I suggest you click on the URL (blue color links) to navigate to the required transformation and find the example with a detailed explanation.

Used to Limit the records from the Top or BottomTypeDescription
AggregatorActive / ConnectedIt is used to perform Aggregate calculations such as SUM, MIN, COUNT, etc.
Application Source QualifierActive / ConnectedIt represents the rows that the Integration Service reads from an application.
CustomActive or Passive / ConnectedIt is used to call Procedures from DLL or shared library
Data MaskingPassive / ConnectedUse this to replace original data (sensitive data) with realistic test data. This is very useful while we are working in a non-production environment.
ExpressionPassive / ConnectedIt helps you to write Custom calculations using Expression Editor.
External ProcedurePassive / Connected or UnconnectedThis is used to call a procedure in a Shared Library or from the Com layer of Windows.
FilterActive / ConnectedUsed to Filter the data
HTTPPassive / ConnectedUse this to connect with HTTP Server and read or update data.
InputPassive / ConnectedThis is available in Mapplet Designer. Use this one to define the Input rows.
JavaActive or Passive / ConnectedThis is very useful for executing the code written in Java.
JoinerActive /ConnectedTo Join data from multiple tables. There are four types of Joins: Normal Join, Master Outer Join, Detail Outer Join, and Full Outer Join.
LookupActive or Passive / Connected or UnconnectedThis Informatica transformation is useful for looking up data in Relational databases or flat files.
NormalizerActive /ConnectedUse this to normalize the data (DE normalized).
OutputPassive / ConnectedThis is available in Mapplet Designer. Use this to define the output rows.
RankActive /ConnectedUsed to Limit the records from Top or Bottom
RouterActive /ConnectedBased on the group condition, it will route the data to multiple destinations or trans.
Sequence GeneratorPassive / ConnectedThis Transformation will generate Numeric values. We mainly use this to generate primary keys.
SorterActive /ConnectedThis is used to Sort the data based on the specified Column or Key
Source QualifierActive /ConnectedIt represents the rows that the Service reads from a Flat File or Relational Database.
SQLActive or Passive / ConnectedIt helps you to execute SQL Queries against a Database
Stored ProcedurePassive / Connected or UnconnectedUse this to call a stored procedure.
Transaction ControlActive / ConnectedBy using this, you can define Commit and Rollback Transactions
UnionActive / ConnectedThis is used to combine or merge data from different databases or sources.
Unstructured DataActive or Passive / ConnectedIt transforms data into a semi-structured or unstructured format.
Update StrategyActive /ConnectedUsed to determine whether to Insert, Update, Delete, or reject Rows.
XML GeneratorActive /ConnectedIt reads data from one or more ports and returns XML
XML ParserActive /ConnectedReads XML file and outputs the data.
XML Source QualifierActive /ConnectedIt represents the records that the Integration Service reads from an XML source.

If you want to save the above-specified list of Informatica Transformations on your Mobile, then use the below image.

Informatica Transformations 3