Tasks

Back Next

Configuring the field mapping

Configure field mappings to define the data that the

data transfer

task writes to the target. Configure field mappings on the

Field Mapping

page.

To match fields with the same name, click

Automap

Exact Field Name

. Or, to match fields with similar names, click

Automap

Smart Map

You can also select and drag the source fields to the applicable target fields.

To configure the field expression, click the mapped field. In the

Field Expression

window, enter the expression you want to use and click

If you create a target at run time and want to add target fields, click

Add

. Configure the following field properties:

Property	Description
Name	Name of the field.
Type	The data type of the data in the column.
Precision	Total number of digits in a number. For example, the number 123.45 has a precision of 5. The precision must be greater than or equal to 1.
Scale	The number of digits to the right of the decimal point of a number. For example, the number 123.45 has a scale of 2. Scale must be greater than or equal to 0. The scale of a number must be less than its precision. The maximum scale for a numeric data type is 65535.