Scribd
Upload
16 views1 page

Active vs Passive Transformations in Informatica

The document defines two types of data warehouse transformations - active transformations which change the number of rows passing through a mapping, such as aggregator and filter transformations, and passive transformations which do not change the row count, like expression and lookup transformations. Specific transformation types are listed under each category.

Uploaded by

Vinay Karnam
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd
16 views1 page

Active vs Passive Transformations in Informatica

The document defines two types of data warehouse transformations - active transformations which change the number of rows passing through a mapping, such as aggregator and filter transformations, and passive transformations which do not change the row count, like expression and lookup transformations. Specific transformation types are listed under each category.

Uploaded by

Vinay Karnam
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as DOCX, PDF, TXT or read online on Scribd

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)

You might also like