You can configure field groups when you define the fields to be normalized. A field group
defines a group of multiple-occuring fields in the source. The Normalizer transformation
returns a row for each group occurrence instead of for each field occurrence.
Configure field groups when the source contains groups of multiple-occuring fields.
When a group of fields occurs multiple times in the source row, you can add child groups
to configure the data hierarchy. The Normalizer transformation returns a row for each
child group occurance multiplied by the parent group occurs value.
For example, a parent group that occurs four times contains a child group that occurs
three times. The child group contains two fields that each occur once. The Normalizer
transformation returns each field 12 times.
The following image shows the
Normalized Fields
tab with parent and
child groups:
The field level identifies the hierarchy of fields. Fields in the same group have the
same level number and display sequentially below the group-level field. You can define
up to ten levels in a group.
You can't configure field groups in
advanced mode or SQL ELT mode.
ASK INFAPreview
