Informatica Transformations – Overview

Transformation Overview

  • A transformation is a repository object that generates, modifies, or passes data.
  • The Designer provides a set of transformations that perform specific functions.
  • Transformations in a mapping represent the operations the Integration Service performs on the data.
  • Transformations can be active or passive.
  • Transformations can be connected to the data flow, or they can be unconnected.
list-of-informatica-transformations
List of informatica Transformations

List of transformations

Here is the list of transformations in Informatica 9.6 power center Designer.

1. Source Qualifier
2. Update Strategy
3. Expression
4. Stored Procedure
5. Sequence Generator
6. Aggregator
7. Filter
8. Lookup
9. Joiner
10. Normalizer
11. Sorter
12. Rank
13. Application Source Qualifier
14. Router
15. Transaction Control
16. HTTP
17. SQL
18. Union
19. Java
20. Data Masking
21. XML Generator
22. XML Parser
23. Unstructured Data
24. XML Source Qualifier

Incorporate a transformation into a mapping

You can create transformations and configure it while doing mapping.
To Include transformation into a mapping, do the following.

1. Create the transformation
2. Configure the transformation (Edit)
3. Link the transformation to other transformations and/or target definitions

create-informatica-transformations
Create and Edit informatica transformations
linking-informatica-transformations
Linked Source Qualifier (SQ) transformation with target

 

Creating a Transformation

We can create transformations using the below designer tools.

1. Transformation Developer
2. Mapplet Designer
3. Mapping Designer

create-informatica-transformation-3-ways
3 ways to create informatica transformations

 

***

If you have any further questions, please do send an e-mail to kvtinformatica@gmail.com.