In Informatica Transformation source data can be transforming consistent with the necessities of target system and it guarantees the quality of data being loaded into target.
It is of two types- Active and Passive
Active Transformation – With the help of Active transformation we can alter the no. of rows which is passes through the transformation and can alter the row type or transaction boundary. For example, Filter, Transaction Control and Update Strategy are active transformations.
The following are the list of active transformations used for processing the data –
- Source quilter transformation
- Filter transformation
- Ruler transformation
- Rank Transformation
- Sorter transformation
- Joiner transformation
- Union Transformation
- Aggregate Transformation
- Transaction control transformation
- Normalize transformation
- Update strategy transformation
- SQL Transformation
Go through the Informatica Course details so that you can get a better understanding of this widely used business intelligence tool.
Passive Transformation – With the help of passive transformation we cannot alter the no. of rows which goes through it and maintains the row type and transaction boundary.
The following are the list of passive transformations used for processing data.
- Expression transformation
- Sequence generated transformation
- Stored procedure transformation
- Look up transformation
- XML source qualifier transformation
- SQL Transformation
Looking for top jobs in Business Intelligence ? This blog post gives you all the information you need!
Transformations can be Connected or Unconnected to the data flow.
Connected Transformation – Connected transformation is linked to other transformations or directly to destination table in the mapping.
Unconnected Transformation – Unconnected transformation is not linked to other transformations in the mapping. It is invoked within a different transformation and gives a value to that transformation.
These are the transformation list in Informatica –
|Aggregator||Active/Connected||Performs aggregate calculations.|
|Application Source Qualifier||Active/Connected||Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.|
|Custom||Active or Passive/Connected||Calls a procedure in a shared library or DLL.|
|Data Masking||Passive/Connected||Replaces sensitive production data with realistic test data for non-production environments.|
|Expression||Passive/Connected||Calculates a value.|
|External Procedure||Passive/Connected or Unconnected||Calls a procedure in a shared library or in the COM layer of Windows.|
|HTTP||Passive/Connected||Connects to an HTTP server to read or update data.|
|Input||Passive/Connected||Defines mapplet input rows. Available in the Mapplet Designer|
|Java||Active or Passive/Connected||Executes user logic coded in Java. The byte code for the user logic is stored in the repository|
|Joiner||Active/Connected||Joins data from different databases or flat file systems.|
|Lookup||Active or Passive/Connected or Unconnected||Lookup and return data from a flat file, relational table, view, or synonym.|
|Normalizer||Active/Connected||Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.|
|Output||Passive/Connected||Defines mapplet output rows. Available in the Mapplet Designer.|
|Rank||Active/Connected||Limits records to a top or bottom range.|
|Router||Active/Connected||Routes data into multiple transformations based on group conditions.|
|Sequence Generator||Passive/Connected||Generates primary keys.|
|Sorter||Active/Connected||Sorts data based on a sort key.|
|Source Qualifier||Active/Connected||Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.|
|SQL||Active or Passive/Connected||Executes SQL queries against a database.|
|Stored Procedure||Passive/Connected or Unconnected||Calls a stored procedure.|
|Transaction Control||Active/Connected||Defines commit and rollback transactions.|
|Union||Active/Connected||Merges data from different databases or flat file systems.|
|Unstructured Data||Active or Passive/Connected||Transforms data in unstructured and semi-structured formats.|
|Update Strategy||Active/Connected||Determines whether to insert, delete, update, or reject rows.|
|XML Generator||Active/Connected||Reads data from one or more input ports and outputs XML through a single output port.|
|XML Parser||Active/Connected||Reads XML from one input port and outputs data to one or more output ports.|
|XML Source Qualifier||Active/Connected||Represents the rows that the Integration Service reads from an XML source when it runs a session.|