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

Duplicate table names from different replication tasks

Duplicate table names from different
replication
tasks

If you replicate multiple source objects with the same names from different
replication
tasks to the same database user account, the
replication
task creates one target table, and overwrites the table data each time you replicate one of the objects. If you run a full load, it overwrites the entire table. If you run an incremental load, it overwrites the changed rows.
To avoid overwriting tables, use a different target table name prefix for each
replication
task.

0 COMMENTS

We’d like to hear from you!