Transformation Guide

Back Next

Transformation Descriptions

The following table provides a brief description of each transformation:

Transformation	Type	Description
Aggregator	Active Connected Native	Performs aggregate calculations.
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.
Custom	Active or Passive Connected Non-native	Calls a procedure in a shared library or DLL.
Data Masking	Passive Connected Non-native	Replaces sensitive production data with realistic test data for non-production environments.
Expression	Passive Connected Native	Calculates a value.
External Procedure	Passive Connected or Unconnected Native	Calls a procedure in a shared library or in the COM layer of Windows.
Filter	Active Connected Native	Filters data.
HTTP	Passive Connected Non-native	Connects to an HTTP server to read or update data.
Input	Passive Connected Native	Defines mapplet input rows. Available in the Mapplet Designer.
Java	Active or Passive Connected Non-native	Executes user logic coded in Java. The byte code for the user logic is stored in the repository.
Joiner	Active Connected Native	Joins data from different databases or flat file systems.
Lookup	Active or Passive Connected or Unconnected Native	Look up and return data from a flat file, relational table, view, or synonym.
Normalizer	Active Connected Native	Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
Output	Passive Connected Native	Defines mapplet output rows. Available in the Mapplet Designer.
Rank	Active Connected Native	Limits records to a top or bottom range.
Router	Active Connected Native	Routes data into multiple transformations based on group conditions.
Sequence Generator	Passive Connected Native	Generates primary keys.
Sorter	Active Connected Native	Sorts data based on a sort key.
Source Qualifier	Active Connected Native	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 Non-native	Executes SQL queries against a database.
Stored Procedure	Passive Connected or Unconnected Native	Calls a stored procedure.
Transaction Control	Active Connected Native	Defines commit and rollback transactions.
Union	Active Connected Non-native	Merges data from different databases or flat file systems.
Unstructured Data	Active or Passive Connected Non-native	Transforms data in unstructured and semi-structured formats.
Update Strategy	Active Connected Native	Determines whether to insert, delete, update, or reject rows.
XML Generator	Active Connected Native	Reads data from one or more input ports and outputs XML through a single output port.
XML Parser	Active Connected Native	Reads XML from one input port and outputs data to one or more output ports.
XML Source Qualifier	Active Connected Native	Represents the rows that the Integration Service reads from an XML source when it runs a session.

When you build a mapping, you add transformations and configure them to handle data according to a business purpose. Complete the following tasks to incorporate a transformation into a mapping:

Create the transformation.
Create it in the Mapping Designer as part of a mapping, in the Mapplet Designer as part of a mapplet, or in the Transformation Developer as a reusable transformation.

Configure the transformation.
Each type of transformation has a unique set of options that you can configure.

Link the transformation to other transformations and target definitions.
Drag one port to another to link them in the mapping or mapplet.

Rename Saved Search

Table of Contents

Transformation Guide

Transformation Guide

Transformation Descriptions

Transformation Descriptions