PowerCenter
- PowerCenter 10.4.0
- All Products
Transformation | Description |
---|---|
Aggregator | Performs aggregate calculations. |
Expression | Calculates a value. |
Filter | Filters data. |
Joiner | Joins data from different databases or flat file systems. |
Lookup | Looks up and returns values from a relational table or a file. |
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 workflow. |
Stored Procedure | Calls a stored procedure. |
Union | Merges data from multiple databases or flat file systems. |
Update Strategy | Determines whether to insert, delete, update, or reject records. |