To define a multiple-occurring field or group, set the occurs value to an integer greater than one. When you set an occurs value to greater than one, the Normalizer transformation creates a generated column ID field for the field or group-level field.

The Normalizer transformation also uses the occurs value to create a corresponding set of output fields. The output fields display on the

Field Mapping

tab of the Normalizer transformation. The naming convention for the output fields is <occurs field name>_<occurs number>.

To define a single-occurring field, set the occurs value for the field to one. Define a single-occurring field to include incoming fields that do not need to be normalized in the normalized fields list.