All the information credit for table below belong to Informatica
- Please note that Transformations can be Active or passive.
- Active transformation can change the number of rows that pass through it, For more information on the different Active transformation, See in the table below .
- Passive transformation does not change the number of rows that pass through it, For more information on the different Passive transformation, See in the table below .
- Please note that transformation can be Connected or Unconnected transformation
- Connected Transformation: Connected transformation mean that it directly connected to other transformations, it should be connected front and back, it can also be connect to the target/source table in the mapping.
- Unconnected Transformation: An unconnected transformation mean that it not connected to other transformations in the mapping. To use it, you will have to call the transformation from another transformation (Similar to calling a function), the transformation will returns a value to the transformation who called it.
|Update Strategy Transformation||Active Connected Native||Determines whether to insert, delete, update, or reject rows.|
|Filter Transformation||Active Connected Native||Filter the data|
|Aggregator Transformations||Active Connected Native||Performs aggregate calculations.|
|Custom Transformation|| Active or Passive
|Calls a procedure in a shared library or DLL.|
|Joiner Transformation||Active Connected Native||Joins data from different databases or flat file systems. Transformations|
|Normalizer Transformation||Active Connected Native||Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.|
|Rank Transformation||Active Connected Native||Limits records to a top or bottom range.|
|Router Transformation||Active Connected Native||Routes data into multiple transformations based on group conditions.|
|Sorter Transformations||Active Connected Native||Sorts data based on a sort key.|
|Transaction control Transformation||Active Connected Native||Defines commit and rollback transactions.|
|Source Qualifier Transformation||Active Connected Native||Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.|
|Application Source qualifier||Active Connected Non-native||Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.|
|Lookup Transformation|| Active or Passive
Connected or Unconnected
|Look up and return data from a flat file, relational table, view, or synonym.|
|Sequence Generator Transformation||Passive Connected Native||Generates primary keys.|
|Stored Procedure Transformation|| Passive
Connected or Unconnected
|Calls a stored procedure.|
|External Procedure Transformation||Passive Connected or Unconnected Native||Calls a procedure in a shared library or in the COM layer of Windows.|
|Expression Transformation||Passive Connected Native||Calculates a value.|
|Mapplet Input||Passive Connected Native||Defines mapplet input rows. Available in the Mapplet Designer.|
|Mapplet Output||Passive Connected Native||Defines mapplet output rows. Available in the Mapplet Designer.|
|XML Source Qualifier Transformation||Active Connected Native||Represents the rows that the Integration Service reads from an XML source when it runs a session.|
|XML Parser Transformation||Active Connected Native||Reads XML from one input port and outputs data to one or more output ports.|
|XML Generator Transformation||Active Connected Native||Reads data from one or more input ports and outputs XML through a single output port.|
|Data Masking Transformation||Passive Connected Non-native||Replaces sensitive production data with realistic test data for non-production environments.|
|HTTP Transformation||Passive Connected Non-Native||Connects to an HTTP server to read or update data.|
|Identity Resolution Transformation||Active||The Identity Resolution transformation is an active transformation that you can use to search and match data in Informatica Identity Resolution (IIR).|
|Java Transformation||Active or Passive Connected Non-native||Executes user logic coded in Java. The byte code for the user logic is stored in the repository.|
|SQL Transformation||Active or Passive Connected Non-native||Executes SQL queries against a database.|
|Unstructured Data Transformation|| Active or Passive
|Transforms data in unstructured and semi-structured formats.|
|Union Transformation||Active Connected Non-native||Merges data from different databases or flat file systems.|
I hope you will enjoy the content of my website.
Please leave me a comment below if you have any suggestion for improving