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

Update columns

Update columns

Update columns are columns that uniquely identify rows in the target table. Add update columns when the database target table does not contain a primary key and the
data transfer
task uses an update, upsert, or delete operation.
When you run the
data transfer
task, the task uses the field mapping to match rows in the source to the database table. If the
data transfer
task matches a source row to multiple target rows, it performs the specified task operation on all matched target rows.

0 COMMENTS

We’d like to hear from you!