The Normalizer transformation is an active transformation that transforms one incoming row into multiple output rows. When the Normalizer transformation receives a row that contains multiple-occurring data, it returns a row for each instance of the multiple-occurring data.
For example, a relational source includes four fields with quarterly sales data. You can configure a Normalizer transformation to generate a separate output row for each quarter.
When the Normalizer transformation returns multiple rows from an incoming row, it returns duplicate data for single-occurring incoming columns.
When you configure a Normalizer transformation, you define Normalizer properties on the following tabs of the
tab. Define the multiple-occurring fields and specify additional fields that you want to use in the mapping.
tab. Connect the incoming fields to the normalized fields.
To use the Normalizer transformation, you need the appropriate license.