Flat 10% & upto 40% off + 10% Cashback + Free additional Courses. Hurry up

Informatica Transformation

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/Passive or Connected/Unconnected.

nformatica Transformations

Active transformation – 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, Transaction Control and Update Strategy are active transformations.

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
  • Aggregate Transformation
  • Transaction control transformation
  • Normalize transformation
  • Update strategy transformation
  • SQL Transformation

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

Passive transformation – With the help of passive transformation we cannot alter the no. of rows which 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
  • Sequence generated transformation
  • Stored procedure transformation
  • Look up transformation
  • XML source qualifier transformation
  • SQL Transformation

Looking for top Informatica jobs? Read this blog for more information!

Transformations can be Connected or Unconnected to the data flow.

Connected transformation – Connected transformation is linked to other transformations or directly to 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 a value to that transformation.

Some of the commonly used transformations in Informatica are –

Transformations Description
Aggregator This transformation is used to perform aggregate calculations such as averages and sums. It performs calculation on row-by-row basis.
Expression This transformation calculates the value in a single row and tests the conditional statements
Filter 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 This transformation joins two heterogeneous sources.
Lookup It searches the data in the relational table and returns it. A user can use multiple lookups at a time.

"0 Responses on Informatica Transformation"

100% Secure Payments. All major credit & debit cards accepted Or Pay by Paypal.

Sales Offer


Sign Up or Login to view the Free Informatica Transformation.