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