- PowerCenter 10.5.1
- All Products
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.
Calls a procedure in a shared library or DLL.
Replaces sensitive production data with realistic test data for non-production environments.
Calculates a value.
Calls a procedure in a shared library or in the COM layer of Windows.
Connects to an HTTP server to read or update data.
Defines mapplet input rows. Available in the Mapplet Designer.
Executes user logic coded in Java. The byte code for the user logic is stored in the repository.
Joins data from different databases or flat file systems.
Look up and return data from a flat file, relational table, view, or synonym.
Source qualifier for COBOL sources. Can also use in the pipeline to normalize data from relational or flat file sources.
Defines mapplet output rows. Available in the Mapplet Designer.
Limits records to a top or bottom range.
Routes data into multiple transformations based on group conditions.
Generates primary keys.
Sorts data based on a sort key.
Represents the rows that the Integration Service reads from a relational or flat file source when it runs a session.
Executes SQL queries against a database.
Calls a stored procedure.
Defines commit and rollback transactions.
Merges data from different databases or flat file systems.
Transforms data in unstructured and semi-structured formats.
Determines whether to insert, delete, update, or reject rows.
Reads data from one or more input ports and outputs XML through a single output port.
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.
Updated July 27, 2022