1. 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 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.

2. 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. 1. Here are two types of transformations based on the change in several rows, such as: Active Transformations Passive Transformations ActiveTransformations are those who modify the data rows, and the number of input rows passed to them. For example, if a transformation receives 10 numbers of rows as input, and it returns 15 numbers of rows as an output, then it is an active transformation. In the active transformation, the data is modified in the row. PassiveTransformations do not change the number of input rows. In passive transformations, the number of input and output rows remains the same, and data is modified at row level only.In the passive transformation, we cannot create new rows, and no existing rows dropped.

3. Contact us +91-9989971070, 70322 90546 Register now for Informatica Cloud Online Training Visit: https://www.visualpath.in/informatica-cloud-training.html