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

Configuring multiple database tables as the source

Configuring multiple database tables as the source

You can configure multiple database tables as the source of a
synchronization
task.
  1. On the
    Source
    page, select a database connection.
    To create a connection, click
    New
    . To edit a connection, click
    View
    and then click
    Edit
    .
  2. Select
    Multiple
    .
    The Source Objects table displays.
  3. Click
    Add
    .
  4. In the
    Select Source Objects
    dialog box, select the objects you want to use.
    The dialog box displays up to 200 objects. If the objects that you want to use do not display, enter a search string to reduce the number of objects that display.
    When you select an object, it appears in the Selected Objects list. To remove an object from the Selected Objects list, press
    Delete
    .
  5. Click
    Select
    .
    The selected sources display in the
    Source Objects
    table. To remove a source, in the
    Actions
    column, click
    Remove
    .
  6. To display source fields in alphabetical order, select
    Display source fields in alphabetical order
    .
    By default, source fields appear in the order returned by the source system.
  7. Create source relationships or create a user-defined join, and click
    OK
    .
    To create a relationship, perform the following steps:
    1. Select a database table and click
      Create Relationship
      .
    2. Select the source key for the table and then select the related source object and matching object key.
    3. Click
      OK
      .
    4. Match the primary key of the source table to the corresponding foreign key of the related database table.
    5. Create relationships as necessary to include all sources in the task.
    To create a user-defined join to join all database tables, perform the following steps:
    1. Select
      User Defined Join
      and define the join.
    2. Any existing relationships are added to the join condition. To ensure that you enter field names correctly, use the
      Object
      list and
      Fields
      list to add field names to the join statement.
    3. To save the user-defined join, click
      OK
      .
  8. To preview source data, select the source in the Source Objects table. If preview data does not appear automatically, click
    Show Data Preview
    .
    The Data Preview area shows the first ten rows of the first five columns in the source. It also displays the total number of columns in the source.
    The Data Preview area does not display certain Unicode characters as expected. If the data contains binary data, the Data Preview area shows the following text:
    BINARY DATA
  9. To preview all source columns in a file, select the source in the Source Objects table and click
    Preview All Columns
    .
    The file shows the first ten rows of the source.
  10. Click
    Next
    .

0 COMMENTS

We’d like to hear from you!