Informatica Transformations Overview

A transformation is an object that reads, modifies and passes the data on. It represents the set operations performed on the data. It can be categorized in two classes- Active and/Passive Informatica Transformations or Connected/Unconnected Transformations in Informatica.
nformatica Transformations

Active Transformation in Informatica

With the help of Active transformation we can alter the no. of rows which is passes through the transformation and can alter the row type or transaction boundary.
For example, Filter Transformation in Informatica, Transaction Control Transformation in Informatica and Update Strategy Transformation in Informatica are active Informatica Transformations.

Watch this Informatica video

Informatica Transformations

The following are the list of active transformation in Informatica used for processing the data –

  • Source quilter transformation in Informatica
  • Filter transformation in Informatica
  • Ruler transformation in Informatica
  • Rank Transformation in Informatica
  • Sorter Transformation in Informatica
  • Joiner Transformation in Informatica
  • Union Transformation in Informatica
  • Aggregate Transformation in Informatica
  • Transaction control transformation in Informatica
  • Normalize transformation in Informatica
  • Update strategy transformation in Informatica
  • SQL Transformation in Informatica

Go through the Informatica course details to get a better understanding of this widely used business intelligence tool.

Passive transformation in Informatica

With the help of passive transformation, we cannot alter the no. of rows that goes through it and maintains the row type and transaction boundary.
The following are the list of passive transformations used for processing data:

  • Expression Transformation in Informatica
  • Sequence generator transformation in Informatica
  • Stored procedure transformation in Informatica
  • Lookup Transformation in Informatica
  • XML source qualifier transformation in Informatica
  • SQL Transformation in Informatica

Prepare yourself for the Top Informatica Interview Questions And Answers


Transformations can be Connected or Unconnected to the data flow.

Connected transformation

Connected transformation is linked to other transformations or directly to a destination table in the mapping.

Unconnected transformation

Unconnected transformation is not linked to other transformations in the mapping. It is invoked within a different transformation and gives value to that transformation.

Become a Business Intelligence Architect

Some of the commonly used transformations in Informatica are:

Informatica Transformations Description
Aggregator Transformation in Informatica This transformation is used to perform aggregate calculations such as averages and sums. It performs a calculation on a row-by-row basis.
Expression Transformation in Informatica This transformation calculates the value in a single row and tests the conditional statements
Filter Transformation in Informatica It filters the rows in a mapping. All the ports are input/output in nature and rows that meet the filter conditions pass through it.
Joiner Transformation in Informatica This transformation joins two heterogeneous sources.
Lookup Transformation in Informatica It searches the data in the relational table and returns it. A user can use multiple lookups at a time.


Course Schedule

Name Date
Power BI Training 2021-12-04 2021-12-05
(Sat-Sun) Weekend batch
View Details
Power BI Training 2021-12-11 2021-12-12
(Sat-Sun) Weekend batch
View Details
Power BI Training 2021-12-18 2021-12-19
(Sat-Sun) Weekend batch
View Details

Leave a Reply

Your email address will not be published. Required fields are marked *