Configure the occurs value for a normalized field to define the number of instances the field occurs in incoming data.
To define a multiple occurring field, set the occurs value for the field 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. The Normalizer transformation also creates a generated key field for all normalized data.
The Normalizer transformation also uses the occurs value to create a corresponding set of output fields. The output fields display on the
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.