Target Transformation Field Mappings
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. You can configure the following field mapping options.
- Field Map Options
- Method to map fields to the target. Use one of the following options:
- - Manual. Manually link incoming fields to target fields. Removes links for automatically mapped fields.
- - 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. Use a parameter to configure links in the mapping that you want to enforce, and display unmapped fields in the task. Or, use a parameter to configure links in the mapping, and allow all fields and links to display in the task for configuration.
- Parameter
- Parameter to use for the field mapping.
- New Parameter
- Creates a field mapping parameter.
- Show Fields
- Controls the fields that appear in the Incoming Fields list. Show all fields, unmapped fields, or mapped fields.
- Automatch
- Links fields with matching names. Allows you to link matching fields, and then manually configure other field mappings.
- 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.
- - Clear all. Clears all field mappings.
- Show
- Determines how field names appear in the target fields list. Use technical field names or labels.