Informatica help

Informatica help and metadata report query

Transformation Types

Transformation Types

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.
Transformation Name Type Description
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
Connected
Non-native
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
Native
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
Native
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
Connected Non-native
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

Leave a Reply

Your email address will not be published.Email address is required.

Sponsored Content


Canon EOS 5D Mark IV Full Frame Digital SLR Camera Body


Canon EF 24-70mm f/2.8L II USM Standard Zoom Lens

GoPro HERO5 Black

Canon EF 100-400mm f/4.5-5.6L IS II USM Lens

Firefield FF16001 NVRS 3x 42mm Gen 1 Night Vision Riflescope, Black

Visitors


Quantcast