Saturday, October 28, 2017

Informatica Transformation Types

Transformation is a repository object that generates, modifies, or passes data. Using Informatica transformations, users can implement business logic and transform the data.

Few more details about Transformations:
  • Power center designer provides a set of transformations to perform specific functions.
  • Transformations in a mapping represent the operations the Integration Service performs on the data.
  • Data passes into and out of transformations through ports that we link in a mapping or mapplet.
  • Transformations can be Active or Passive.
  • An active transformation can change the number of rows that pass  through it.
  • A passive transformation does not change the number of rows that    pass through it.
  • Transformations can be connected to the data flow.
  • An unconnected transformation is not connected to other transformations in the mapping.
  • It is called within another transformation, and returns a value to that  transformation.
The below video will describes types of Informatica transformations. And why a transformation is called an active or passive transformation

1 comment: