Tasks

Back Next

Configuring the field mapping

Configure field mappings to define the data that the

synchronization

task writes to the target.

On the

Field Mapping

page, configure field mappings.

If you included multiple source objects in the task, you can select each source object in the

Source

field to display the fields for the selected object. Or, you can view all source object fields.

When displaying all source object fields, the

Sources

table displays field names grouped by source object. You can place the cursor over the Status icon for a source field to determine the following information:

Database table or Salesforce object to which the field belongs.

data type of a field.

Some source types allow you to configure field data types. To configure field data types for a source, click

Edit Types

If the task includes more than one source, first select the source you want to edit.

In the

Edit Field Datatypes

dialog box, configure the following data type attributes and click

data type attribute	Description
Datatype	The data type of 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	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.

To add a mapplet, complete the following steps:

Click

Add Mapplet

In the

Add Mapplet

dialog box, select the mapplet.

To display technical names instead of business names, select

Display technical field names instead of labels

To display fields in alphabetical order, click

Display mapplet fields in alphabetical order

By default, fields appear in the order specified by the mapplet.

If necessary, select a connection for the mapplet.

Click

To configure field mappings, for

Mapping Selection

, select one of the following options:

Source to Target

. Displays the source and target. Map source fields to the applicable target fields.

Source to Mapplet

. Displays the source and the input fields of the mapplet. Map the source fields to the applicable input fields of the mapplet.

Mapplet to Target

. Displays the output fields of the mapplet and the target fields. Map the output fields of the mapplet to the applicable target fields.

The

Clear Mapping

Automap

, and

Validate Mapping

buttons apply to the selected area of the field mapping.

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.

Data Integration

caches field metadata. If the fields do not appear correctly, click

Refresh Fields

to update the cache and view the latest field attributes.

To configure field data types for a target, click

Edit Types

This option is not available for all target types. If the task includes more than one target, first select the target you want to edit.

In the

Edit Field Datatypes

dialog box, configure the following data type attributes and click

data type attribute	Description
Datatype	The data type of 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	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.

To create an expression to transform data, click the

Add or Edit Expression

icon in the

Actions

column.

In the

Field Expressions

dialog box, enter the expression you want to use and click

You can use parameters defined in a parameter file in expressions.

To create a lookup, click the

Add or Edit Lookup

icon.

In the

Field Lookup

dialog box, configure the following properties and click

Option	Description
Lookup Connection	Connection for the lookup object.
Lookup Object	Object on which you want to lookup a value.
Display Technical Field Names Instead of Labels	Displays technical names instead of business names. Not available for all connection types.
Display Fields in Alphabetical Order	Displays lookup fields in alphabetical order. By default, fields appear in the order returned by the lookup system.
Source Fields	Source column to use in the lookup condition.
Lookup Fields	The column in the lookup table to use in the lookup condition.
Output Field	The column in the lookup table that contains the output value.
Multiplicity	Determines how to handle cases when a lookup returns multiple values: Error If More Than 1 Output Value. Select if the synchronization task should display an error when the lookup condition returns multiple values. Data Integration rejects rows when multiple matches are found, writing them to the error rows file. This is the default. Randomly Pick 1 Output Value. Select if the synchronization task should choose the first returned value when a lookup condition returns multiple values. Different systems might use different orders to return lookup values.
Expression	A simple expression that uses the $OutputField variable to represent the lookup return value. Enter a simple expression, such as $OutputField*100. You can use parameters defined in a parameter file in lookup expressions. To return the lookup return value without an additional expression, use $OutputField.