Transformations List and Overview:

Transformations Overview:

A transformation is a repository object that can be generates, modifies, or passes data. The Designer provides a set of transformations that perform specific functions.

Transformations in a mapping represent the operations the Integration Service performs on the data. Data passes through transformation ports that you link in a mapping or mapplet.

 Transformations can be active or passive. Transformations can be connected to the data flow, or they can be unconnected.

Active: A transformation that can Change the number of rows that pass through the transformation

Passive: A transformation does not change the number of rows that pass through the transformation

Note: Transformation may be unconnected like Store Procedure, Un-Connected Lookup.

List of Transformation and its Descriptions:

Source Qualifier:

Source Qualifier is a Active/Connected transformation. It Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.

Aggregator:

Aggregator is an Active/Connected transformation. It Performs aggregate calculations like Sum, Max, Min, Avg, Count,..etc.

Application Source Qualifier:

Application Source Qualifier is Active/Connected transformation. Represents the rows that the Integration Service reads from an application, such as an ERP source, when it runs a session.

Expression:

Expression is Passive/Connected transformation. It Calculates a value in a single row.

Filter:

Filter is Active/Connected transformation. It Filters data.

Joiner:

Joiner is a Active/Connected transformation. It Joins data from different databases or flat file systems.

Lookup:

Lookup is a Active or Passive/Connected or Unconnected transformation. It Look up and return data from a flat file, relational table, view, or synonym.

Normalizer:

Normalizer is a Active/Connected transformation. It is used as Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.

Rank:

Rank is a Active/Connected transformation. It limits records to a top or bottom range.

Router:

Router is a Active/Connected transformation. It Routes data into multiple transformations based on group conditions.

Sequence Generator:

Sequence Generator is a Passive/Connected transformation. It Generates primary keys.

Sorter:
Sorter is a Active/Connected transformation. It Sorts data based on a sort key.

SQL:

SQL is a Active or Passive/Connected transformation. It Executes SQL queries against a database.

Stored Procedure:

Stored Procedure is a Passive/Connected or Unconnected transformation. It Calls a stored procedure.

Transaction Control:

Transaction Control is a Active/Connected transformation. It defines commit and rollback transactions.

Union:
Union is a Active/Connected transformation. It Merges data from different databases or flat file systems.

Update Strategy:

Update Strategy is a Active/Connected transformation. It Determines whether to insert, delete, update, or reject rows.

XML:
XMLGenerator is a Active/Connected transformation. It Reads data from one or more input ports and outputs XML through a single output port.

XMLParser is a Active/Connected transformation. It Reads XML from one input port and outputs data to one or more output ports.

XML Source Qualifier is a Active/Connected transformation. It Represents the rows that the Integration Service reads from an XML source when it runs a session.