Informatica Power Center is an Extract, Transform, Load (ETL) tool developed and provided by the Informatica Corporation.
Informatica is one of the best platforms that is used to read, transform, and integrate data from a source (for example: files or database) to target. (for example: files or databases).
Informatica offers a wide variety of tools for data operation like-
- Informatica Power Center (IPC)
- Informatica Integrated Cloud Service (IICS)
- Informatica Data Quality
- Informatica Master Data Management (MDM)
Here, I am describing different transformation types in Informatica Power Center or Informatica Integrated Cloud Service (IICS).
Informatica Transformations Types | Classifications
- Update Strategy Transformation
- Expression Transformation
- Filter Transformation
- Aggregator Transformation
- Lookup Transformation
- Sequence Generator Transformation
- Stored Procedure Transformation
- External Procedure Transformation
- Custom Transformation
- Joiner Transformation
- Normalizer Transformation
- Rank Transformation
- Router Transformation
- Sorter Transformation
- Transaction Control Transformation
- Source Qualifier Transformation
- Flexible Target Key Transformation
- HTTP Transformation
- Web Service Consumer Transformation
- SQL Transformation
- Union Transformation
- Java Transformation
- Salesforce Lookup Transformation
- Salesforce Picklist Transformation
- Salesforce Merge Transformation
- XML Parser Transformation
- XML Generator Transformation
- Identity Resolution Transformation
- Unstructured Data Transformation
- Data Masking Transformation
These types of transformations are available in the Informatica. Each transformation serves different purposes. Informatica developer used some of these transformations based on given business logic.
Read more related articles:
- Active transformation vs Passive transformation in Informatica | Examples
- Filter transformation vs Router transformation in Informatica
- Source qualifier (SQ) transformation and Joiner transformation in Informatica
- Joiner transformation vs Lookup transformation in Informatica
I have completed master in Electrical Power System. I work and write technical tutorials on the PLC, MATLAB programming, and Electrical on DipsLab.com portal.
Sharing my knowledge on this blog makes me happy. And sometimes I delve in Python programming.