You can configure a Normalizer transformation in a mapping to return 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.
In advanced mode, you can configure a Normalizer transformation with the following restrictions:
To normalize multiple-occurring fields from different groups, map each group to a unique target and exclude all fields that are from different groups from the list of incoming fields even though the groups are not mapped to the target.
To write normalized data to multiple targets, map all generated column IDs of normalized fields to the corresponding targets.