The Normalizer transformation generates a separate output row for each quarter of sales and writes the normalized sales amounts to a the Sales target. The Normalizer transformation writes the Store information to a Store target.

The following figure shows the Normalizer transformation mapping:

The mapping contains the following objects:

Read_STORE

A data source that contains multiple-occurring fields.

StoreID Sequence Generator transformation

A Sequence Generator transformation that generates a storeID key to link the Store table to the Sales table.

Sales_Normalizer

A Normalizer transformation that normalizes the multiple-occurring sales data.

Write_Store

A target that receives the store information from the Normalizer transformation.

Write_Sales

A target that receives the sales numbers from the Normalizer transformation.