Tasks

Back Next

Field mappings

Configure field mappings in a

synchronization

task to map source columns to target columns.

Configure field mapping on the

Field Mapping

page of the

synchronization

task wizard.

You must map at least one source column to a target column. Map columns with compatible data types or create field expressions to convert data types appropriately.

Depending on the task operation, the

synchronization

task requires certain fields to be included in the field mapping. By default, the

synchronization

task maps the required fields. If you configure the field mapping, ensure that the required fields remain mapped. If you do not map the required fields, the

synchronization

task fails.

The following table shows the required fields for each applicable task operation for a database target:

Required field	Task operations	Description
Primary Keys	Delete Update Upsert	Map primary key columns to enable the synchronization task to identify records to delete, update, or upsert in a database target.
Non-null fields	Insert Update Upsert	Map all fields that cannot be null in database.