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 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. Active Transformation in Informatica  – With the help of Active

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 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 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

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 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.

Some of the commonly used transformations in Informatica are –

Informatica TransformationsDescription
Aggregator Transformation in InformaticaThis 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 InformaticaIt 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 InformaticaThis transformation joins two heterogeneous sources.
Lookup Transformation in InformaticaIt searches the data in the relational table and returns it. A user can use multiple lookups at a time.

Go for the most professional Informatica Training Course for a stellar career now!

Recommended Videos

Leave a Reply

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

Solve : *
2 + 21 =