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