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.