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

Rules and guidelines for multiple-object databases

Rules and guidelines for multiple-object databases

Use the following rules and guidelines when you configure a multiple-object database:
  • All objects must be available through the same source connection. All database tables in a multiple-object source must have valid relationships defined by key columns or user-defined join conditions.
  • When you add multiple database tables as sources for a task, you can either create relationships or user-defined joins, but not both.
  • The
    synchronization
    task wizard removes a user-defined join under the following conditions:
    • You remove one of two remaining database tables from the list of sources for the task.
    • You change the source connection from database to flat file or Salesforce.

0 COMMENTS

We’d like to hear from you!