The following example shows how to define a Normalizer transformation to return the sales data to a Store target and a Sales target. The Store target receives one row for each store. The Sales target receives four rows from each store. Each row contains one quarter of sales data.

A Sequence Generator transformation generates a unique ID for each store. The Normalizer transformation returns the StoreID with each output row.

Create a mapping with a Read transformation, a Sequence Generator transformation, the Normalizer transformation, and two Write transformations.