Transformation

"Transformation" is informatica object which is used to read, manupulate and load data. There are two types of transformation namely "active" and "passive". Each transformations perform specific functions. Data pass in and out from the transformation through "ports". Ports can be of following type
1. Input only
2. Output only
3. Input & Output
4. Variable.

Transformation can be connected to the data flow or they can be unconnected. Unconnected transformation are not connected to any other transformation in the mapping. These unconnected transformation are called within other transformation and returns a value to that transformation.

Active Transformation: They change the number of rows or property of the output rows.

List of Active transformation
-----------------------------------
Aggregator
Source Qualifier
Custom ( can be active or passive)
Filter
Joiner
Normalizer
Rank
Router
Sorter
Transaction Control
Union
Update Strategy
XML Generator
XML Parser
XML Source Qualifier

Passive Transformation: They don't change number of rows or property of output rows from the transfromation.

List of Passive Transformation
-------------------------------------
Expression
External procedure
Input ( Mapplet transformation)
Lookup
Output ( Mapplet Transformation)
Sequence Generator

Enjoy. Next we will talk detail about each transformation.