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 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
Creating a Transformation
We can create transformations using the below designer tools.
1. Transformation Developer
2. Mapplet Designer
3. Mapping Designer
***
If you have any further questions, please do send an e-mail to kvtinformatica@gmail.com.