Map incoming fields to normalized fields on the Field Mapping tab of the Normalizer transformation.
When you configure the Normalizer field mappings, complete the following steps:
1Map the multiple-occurring incoming fields that you want to normalize to the corresponding output fields that the Normalizer transformation created.
Note: Map at least one output field for each set of normalized fields.
2Map incoming fields to all normalized fields with a single occurrence.
Normalizer field mapping options
You can use the following field mapping options on the Normalizer Field Mapping tab.
Show Fields
Controls the fields that appear in the Incoming Fields list. Show all fields, unmapped fields, or mapped fields.
Automap
Links fields with matching names. Allows you to link matching fields, and then manually configure other field mappings.
You can map fields in the following ways:
- Exact Field Name. Data Integration matches fields of the same name.
- Smart Map. Data Integration matches fields with similar names. For example, if you have an incoming field Cust_Name and a target field Customer_Name, Data Integration automatically links the Cust_Name field with the Customer_Name field.
You can use both Exact Field Name and Smart Map in the same field mapping. For example, use Exact Field Name to match fields with the same name and then use Smart Map to map fields with similar names.
You can undo all automapped field mappings by clicking Automap > Undo Automap. To unmap a single field, select the field to unmap and click Actions > Unmap.
Data Integration highlights newly mapped fields. For example, when you use Exact Field Name, Data Integration highlights the mapped fields. If you then use Smart Map, Data Integration only highlights the fields mapped using Smart Map.
Action menu
Additional field link options. Provides the following options:
- Map Selected. Links the selected incoming field with the selected target field.
- Unmap Selected. Clears the link for the selected field.