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

Reset a database target

Reset a database target

To drop all of the target tables in the task, reset a relational target table in a
replication
task.
You might want to drop a target table when you want to re-create it based on the latest source object definition. When you reset target tables for a
replication
task, the task performs the following actions:
  1. Drops all of the target tables included in the
    replication
    task from the database.
  2. Sets the load type for the
    replication
    task to full load.
After you run the
replication
task to reset the target, you must run the
replication
task again to reload the data from all source objects included in the task. When you run the
replication
task after you reset the target, the
replication
task recreates each target table. The
replication
task then loads all of the data into the new table.
If the target table is damaged, the
replication
task might consistently fail to write to the target table. You might need to reset the relational target.

0 COMMENTS

We’d like to hear from you!