The pipeline Normalizer transformation receives a row that contains multiple-occurring columns and returns a row for each instance of the multiple-occurring data. The transformation processes multiple-occurring columns or multiple-occurring groups of columns in each source row.

For example, you might have a relational table that stores four quarters of sales by store. You need to create a row for each sales occurrence. You can configure a pipeline Normalizer transformation to return a separate row for each quarter.

Use the pipeline Normalizer transformation to process multiple-occurring data from relational tables or flat files. You cannot use a VSAM Normalizer in Mapping Architect for Visio.

The following table describes the required properties for the pipeline Normalizer transformation:

You must set the All Ports rule to link ports in the previous transformation or source qualifier to ports in a pipeline Normalizer transformation. Depending on the number of occurrences for a field, Mapping Architect for Visio can generate additional ports.