Informatica Transformations

Informatica Transformations are repository objects which can create, read, modifies, or passes data to the defined target structures such as tables, files, or any other targets.

In Informatica, the purpose of transformation is to modify the source data according to the requirement of the target system. It also ensures the quality of the data being loaded into the target.

A Transformation is used to represent a set of rules, which define the data flow and how the data is loaded into the targets.

Informatica provides multiple transformations to perform specific functionalities.

In transformations, To passing the data, we need to connect the ports to it, and through the output ports, it returns the output.

Classification of Transformation

Transformation is classified into two categories-the first one based on connectivity and second based on the change in several rows. First, we will look at the transformation based on connectivity.

1. Here are two types of transformation based on connectivity, such as:

• Connected Transformations
• Unconnected Transformations

In Informatica, one transformation is connected to other transformations during mappings are called connected transformations.

For example, Source qualifier transformation of Source table Stud is connected to filter transformation to filter students of a class.

Those transformations whose not link to any other transformations are called unconnected transformations.

Their functionality is used by calling them inside other transformations. And these transformations are not part of the pipeline.

The connected transformations are preferred when the transformation is called for every input row or expected to return a value.The unconnected transformations are useful if their functionality is required periodically only or based upon certain conditions. For example, calculate the tax details if tax value is not available.