Transformations > Transformations > Transformation Types
  

Transformation Types

After you add a transformation to a mapping, you can define transformation details. Each transformation type has a unique set of options that you can configure.
The following table provides a brief description of the transformations that you can use in a mapping:
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.