Transformation is a repository object which can create or modify the data.
There are two types of Transformations
1.Active Transformation
Active Transformation is one which will change the input row count.
If a Transformation is supplied with ‘N’ input rows and if it returns less than or greater than ‘N’ output rows, then it is Active Transformation.
Ex: Filter, Rank, Sorter, etc.
2.Passive Transformation
Passive Transformation is one which will not change the input row count.
If a Transformation supplied with ‘N’ input rows and returns the same ‘N’ output rows then it is called Passive Transformation.
Ex: Expression, Sequence Generator, Lookup, etc.
Different Types of Active and Passive Transformations are
•Source qualifier Transformation
•Filter transformation
•Router Transformation
•Expression Transformation
•Sorter Transformation
•Aggregator Transformation
•Sequence Generator Transformation
•Rank Transformation
•Joiner Transformation
•Union Transformation
•Update Strategy Transformation
•Java Transformation
•SQL Transformation
•Lookup Transformation
•SCD1
•SCD2
•SCD3
There are two types of Transformations
1.Active Transformation
Active Transformation is one which will change the input row count.
If a Transformation is supplied with ‘N’ input rows and if it returns less than or greater than ‘N’ output rows, then it is Active Transformation.
Ex: Filter, Rank, Sorter, etc.
2.Passive Transformation
Passive Transformation is one which will not change the input row count.
If a Transformation supplied with ‘N’ input rows and returns the same ‘N’ output rows then it is called Passive Transformation.
Ex: Expression, Sequence Generator, Lookup, etc.
Different Types of Active and Passive Transformations are
•Source qualifier Transformation
•Filter transformation
•Router Transformation
•Expression Transformation
•Sorter Transformation
•Aggregator Transformation
•Sequence Generator Transformation
•Rank Transformation
•Joiner Transformation
•Union Transformation
•Update Strategy Transformation
•Java Transformation
•SQL Transformation
•Lookup Transformation
•SCD1
•SCD2
•SCD3
