Active Transformation
An Active transformation can change teh number of rows that pass through it from source to traget. It eliminates rows that do not meet the condition in transformation.
Passive Transformation
A Passive transformation does not change teh number of rows that pass through it i.e., it passes all rows through the transformation.
List of transformations coming under Active transformations are -
Source Qualifier Transformation
Aggregator Transformation
Filter Transformation
Rank Transformation
Joiner Transformation
Router Transformation
Normalizer Transformation
Update strategy Transformation
Sorter Transformation
ERP Source Qualifier Transformation
Advanced External Procedure Transformation
And here find the Passive Transformations list -
Expression Transformation
Sequence Generatoe Transformation
LookUP Transformation
Stored Procedure Transformation
XML Source Qualifier Transformation
External procedure Transformation
Input Transformation(Mapplet)
Output Transformation(Mapplet)