What are Informatica Transformations?
[Submitted by: Radhika, Michigan, US.]
In Informatica, Transformations help to transform the source data according to the requirements of target system and it ensures the quality of the data being loaded into target.
Transformations are of two types: Active and Passive.
An active transformation can change the number of rows that pass through it from source to target i.e it eliminates rows that do not meet the condition in transformation.
A passive transformation does not change the number of rows that pass through it i.e it passes all rows through the transformation.
Transformations can be Connected or UnConnected.
Connected transformation is connected to other transformations or directly to target table in the mapping.
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.
Following are the list of Transformations available in Informatica:
- Aggregator Transformation
- Expression Transformation
- Filter Transformation
- Joiner Transformation
- Lookup Transformation
- Normalizer Transformation
- Rank Transformation
- Router Transformation
- Sequence Generator Transformation
- Stored Procedure Transformation
- Sorter Transformation
- Update Strategy Transformation
- XML Source Qualifier Transformation
- Advanced External Procedure Transformation
- External Transformation
In the following pages, we will explain all the above Informatica Transformations and their significance in the ETL process in detail.