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

Replicate data to a database target

Replicate data to a database target

For a
replication
task configured with the full load type, the first time you run the task, the task creates the database tables. The
replication
task then writes the replicated data to the tables. During subsequent runs, the task truncates the database tables and then writes the source data to the tables.
For a
replication
task configured with the incremental load after initial full load type, the first time you run the task, the task creates the database tables. The
replication
task then writes the replicated data to the tables. During subsequent runs, the task performs an upsert operation.
For a
replication
task configured with the incremental load after initial partial load, the first time you run the task and for subsequent runs, the task performs an upsert to replicate source data from the specified period in time.

0 COMMENTS

We’d like to hear from you!