What is a Transformation?
- A Transformation is a repository object that generates, modifies or passes data.
- It is the logic to Informatica to transform the data according to the business needs.
Types of Transformations
Transformations are basically of two types:
A transformation is called as an active transformation if it allows change in the record count.
e.g. If there are 20 records coming from the source but only 5 are sent to the target after transformation.
A transformation is called as a passive transformation if it does not allow any change in the record count.
e.g. If there are 20 records coming from the source and all 20 are sent to the target after transformation.
What are Ports?
- Column names are called Ports.
- Every transformation identifies incoming data with input ports.
- Every transformation works on input ports, output ports and some internal ports.
- Based on the ports and properties the functionality of the transformation will change.
What are the different ways to use a Transformation?
A transformation can be used in two ways:
In a pipeline .The transformation used in a mapping are said to be in a pipeline.
Outside the pipeline.
Commonly used Transformations
|12||Stored Procedure (connected/unconnected)||Passive|
|15||XML Source Qualifier||Active|
|17||Application Source Qualifier (SAP Application Sources)||Active|
|18||Application Multigroup Source Qualifier (SAP Application Sources)||Active|
|19||MQ-Series (Message Queuing System)||Active|
|20||Midstream XML Generator (TIBCO)||Active|
|21||Midstream XML Parser (TIBCO)||Active|