Tuesday, February 26, 2013

List of Active and Passive Transformations in Informatica?


List of Active and Passive Transformations in Informatica?

Active Transformation - An active transformation changes the number of rows that pass through the mapping.

  1. Source Qualifier Transformation
  2. Sorter Transformations
  3. Aggregator Transformations
  4. Filter Transformation
  5. Union Transformation
  6. Joiner Transformation
  7. Normalizer Transformation
  8. Rank Transformation
  9. Router Transformation
  10. Update Strategy Transformation
  11. Advanced External Procedure Transformation
Passive Transformation - Passive transformations do not change the number of rows that pass through the mapping.

  1. Expression Transformation
  2. Sequence Generator Transformation
  3. Lookup Transformation
  4. Stored Procedure Transformation
  5. XML Source Qualifier Transformation
  6. External Procedure Transformation
  7. Input Transformation(Mapplet)
  8. Output Transformation(Mapplet)

 

5 comments: