Transformation | Description |
|---|---|
Source | Reads data from a source. |
Target | Writes data to a target. |
Aggregator | An active transformation that performs aggregate calculations on groups of data. |
Data Masking | A passive transformation that masks sensitive data as realistic test data for nonproduction environments. |
Expression | A passive transformation that performs calculations on individual rows of data. |
Filter | An active transformation that filters data from the data flow. |
Joiner | An active transformation that joins data from two sources. |
Lookup | Looks up data from a lookup object. Defines the lookup object and lookup connection. Also defines the lookup condition and the return values. A passive lookup transformation returns one row. An active lookup transformation returns more than one row. |
Mapplet | Inserts a mapplet into a mapping. A mapplet contains PowerCenter transformation logic that you can create and use to transform data before it is loaded into the target. Can be active or passive based on the transformation logic in the mapplet. |
Normalizer | Processes data with multiple-occurring fields and returns a row for each instance of the multiple-occurring data. |
Router | An active transformation that you can use to apply a condition to incoming data. |
Sequence Generator | A passive transformation that generates a sequence of values. |
Sorter | A passive transformation that sorts data in ascending or descending order, according to a specified sort condition. |
SQL | A passive transformation that calls a stored procedure or function. |
Structure Parser | A passive transformation that analyzes unstructured data from a flat file source and writes the data in a structured format. |
Union | An active transformation that merges data from two input groups into a single output group. |
Web Services | An active transformation that connects to a web service as a web service client to access, transform, or deliver data. |