Following are the list of Transformations available in Informatica:
- Aggregator Transformation
- Application Source Qualifier Transformation
- Custom Transformation
- Data Masking Transformation
- Expression Transformation
- External Procedure Transformation
- Filter Transformation
- HTTP Transformation
- Input Transformation
- Java Transformation
- Joiner Transformation
- Lookup Transformation
- Normalizer Transformation
- Output Transformation
- Rank Transformation
- Reusable Transformation
- Router Transformation
- Sequence Generator Transformation
- Sorter Transformation
- Source Qualifier Transformation
- SQL Transformation
- Stored Procedure Transformation
- Transaction Control Transaction
- Union Transformation
- Unstructured Data Transformation
- Update Strategy Transformation
- XML Generator Transformation
- XML Parser 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 significances in the ETL process in detail.