Configure field mapping in a data transfer task to map source fields to target fields. Configure field mapping on the Field Mapping page of the data transfer task wizard.
You must map at least one source field to a target field. If the task uses multiple sources, fields from the original source are prefixed with the characters SRC_ or IN_SRC_.
You can configure the following field mapping options:
Options
Configure which fields to display. Click Options and select from the following display options:
- Show All
- Show Mapped
- Show Unmapped
Automap
Data Integration automatically links fields with the same name or similar name. Click Automap and select from the following mapping options:
- 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.
- Undo Automap. Data Integration clears fields mapping with Smart Map or Exact Field Name but does not clear manually mapped fields.
Actions
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 Mapping. Clears all field mappings.
After you map a field, if you want to configure a field expression, click the mapped field name. You can include fields and built-in functions in the expression but not user-defined functions.
When you create a target at run time, Data Integration maps the source fields to the target fields. You cannot unmap or edit the source fields mapped to the target but you can add fields to the target. You can also edit the mapped field expression and metadata and reorder the added fields. You cannot reorder the fields copied from the source.