Configure field mappings in a Target transformation to define how data moves from the data flow to the target object.
Configure field mappings on the
Field Mappings
tab.
The
Field Mappings
tab includes a list of incoming fields and a list of target fields.
You can configure the following field mapping options:
Target Field Group
The target field group that lists the tables for which you want to configure field mappings. This option appears when the transformation target type is
Multi Group
.
Field Mapping Type
Method of mapping incoming fields to target fields. Select one of the following options:
Manual. Manually link incoming fields to target fields. Selecting this option removes links for automatically mapped fields. To map fields manually, drag a field from the incoming fields list and position it next to the appropriate field in the target fields list. Or, you can map selected fields, unmap selected fields, or clear all of the mappings using the
Actions
menu.
Automatic. Automatically link fields with the same name. Use when all of the fields that you want to link share the same name. You cannot manually link fields with this option.
Completely Parameterized. Use a parameter to represent the field mapping. In the task, you can configure all field mappings.
Partially Parameterized. Configure links in the mapping that you want to enforce and use a parameter to allow other fields to be mapped in the mapping task. Or, use a parameter to configure links in the mapping, and allow all fields and links to display in the task for configuration.
To see more information on field mapping parameters, see
Mappings
.
Options
You can configure how the fields display and which fields to display. To do so, click
Options
and select from the following display options:
Display fields using field labels or technical field names.
Show mapped, unmapped, or all fields.
Automap Options
If you want
Data Integration
to
automatically link fields with the same name and you also want to manually
map fields, select the
Manual
option and open the
Automap Options
menu.
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 Options
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.
ASK INFAPreview
