Monday 16 April 2012

Informatica Complete Guide On Transformations

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.

No comments:

Post a Comment