Table of Contents

Search

  1. Preface
  2. Data integration tasks
  3. Mapping tasks
  4. Dynamic mapping tasks
  5. Synchronization tasks
  6. Data transfer tasks
  7. Replication tasks
  8. Masking tasks
  9. Masking rules
  10. PowerCenter tasks

Tasks

Tasks

Field mappings

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.
When you configure field mappings, you can also perform the following tasks:
  • Edit field data types.
  • Add a mapplet to the field mapping.
  • Create lookups.

0 COMMENTS

We’d like to hear from you!