Configure the occurs value for a normalized field to define the number of instances the
field or group of fields occurs in incoming data.
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.