A key value that the transformation generates for the first group-level field or the first multiple-occurring field. The transformation also generates a key value for all multiple-occurring groups with at least one multiple-occuring child group or field.

The naming convention for the Normalizer generated key is GK_<redefined_field_name>.

When the first normalized field is a multiple-occuring group that contains a multiple-occuring child field or group, the Normalizer transformation generates two key values for the parent group. The transformation appends the second generated key with "_1"

A column ID value that represents the instance of the multiple-occurring data. For example, if an Expenses field that includes four occurs, the task uses values 1 through 4 to represent each type of occurring data.

The Normalizer transformation uses a generated column ID for each field configured to occur more than one time.

The naming convention for the Normalizer generated key is GCID_<redefined_field_name>.

An

advanced cluster

processes the generated column ID field as a bigint. The Data Integration Server processes the ID as an integer.