Informatica transformation is the entity that generates, modifies or transfers data to the target structures (tables, files or any other destination).
The Informatica transformation aims at adjusting the source data according to the target framework specification. It also guarantees the reliability of the packed data into the destination. To perform specific functionalities, Informatica offers numerous transformations.
For example, calculation of taxes based on source data, the activity of data cleaning, etc. We connect the ports in transformations to transfer data to it, and the transformation returns the information through the output ports.
Classification of Transformation
Transition is divided into two groups, one based on compatibility, and another based on the number of rows increasing. Next, we’ll look at the connectivity-based transition.
Types of transformation based on connectivity
- Connected Transformations
- Unconnected Transformations
The transformations related to other transformations are called connected transformations in Informatica during mapping.
Source qualifier transformation of Source table EMP, for instance, is related to source transformation to filter department employees.
Those transformations that are not connected to other transformations are called transformations that are not related.
Within other transformations such as Expression Transformation, their functionality is used by naming them.
When the transformation is called and is supposed to return a value for that input line, the related transformations are favored. For example, the transformation returning the name of the city for the zip codes in that row.
Unconnected transformations are useful when their functionality is needed only on a regular basis or based on certain conditions. For example, if the tax value is not available, measure the tax information.
Types of transformations based on the change in no of rows
- Active Transformations
- Passive Transformations
Effective Transformations are those that change the rows of data and the number of rows of input passed to them. For example, if a transformation receives ten rows as input and returns fifteen rows as output, it is an effective transformation. In the effective transformation, the data in the line is also modified.
Those who do not change the number of input rows are passive transformations. The number of input and output rows remains the same in passive transformations, only data is changed at row level. No new rows are formed in the passive transition, or existing rows are removed.
List of Transformations in Informatica
- Source Qualifier Transformation
- Aggregator Transformation
- Router Transformation
- Joiner transformation
- Rank Transformation
- Sequence Generator Transformation
- Transaction Control Transformation
- Lookup and Re-usable transformation
- Normalizer Transformation
- Performance Tuning for Transformation
- External Transformation
- Expression Transformation