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

Replication prerequisite tasks

Replication
prerequisite tasks

Complete the following prerequisite tasks before you create a
replication
task:
  1. Verify that a database target exists.
    To replicate data to a database target, the database target must exist before you create the
    replication
    task. If a database does not exist, the database administrator must create a target database. The database must meet the minimum system requirements.
  2. Create database users.
    To replicate data to a database target, the database administrator must create a database user account in the target database. Each database user account must have the CREATE, DELETE, DROP, INSERT, SELECT, and UPDATE privileges. You must have a database user account for each
    replication
    task that writes to that database. You can use the same database user account for multiple
    replication
    tasks. If you use the same database user account for multiple groups, ensure that the
    replication
    tasks do not overwrite data in the same target tables.
  3. Create a directory for the flat files.
    To replicate data to a flat file, create a directory to store the flat files.
  4. Optionally, create a schedule.
    To run
    replication
    tasks at specified times or on regular intervals, create a schedule.

0 COMMENTS

We’d like to hear from you!