Introduction On Transformation:
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data.
Transformations in a mapping represent the operations the Integration Service performs on the data. Data passes through transformation ports that you link in a mapping or mapplet.
Active Transformation:
Change the number of rows that pass through the transformation.
Change the row type
Change the transaction boundary
Passive Transformations
A passive transformation does not change the number of rows that pass through the transformation, maintains the transaction boundary, and maintains the row type.
A transformation is a repository object that generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions. For example, an Aggregator transformation performs calculations on groups of data.
Transformations in a mapping represent the operations the Integration Service performs on the data. Data passes through transformation ports that you link in a mapping or mapplet.
Active Transformation:
Change the number of rows that pass through the transformation.
Change the row type
Change the transaction boundary
Passive Transformations
A passive transformation does not change the number of rows that pass through the transformation, maintains the transaction boundary, and maintains the row type.
