Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Adding Another Capture Registration

Adding Another Capture Registration

After PowerExchange Express CDC for Oracle is running, you might need to add a capture registration for another Oracle table.
  1. In PowerExchange Navigator, create the capture registration.
    Make sure that you include the following settings:
    • In the
      Condense
      list, select
      Part
      .
    • In the
      Supplement Log Group Name
      box, enter a name for the supplemental log group for the table. The PowerExchange Navigator generates DDL for creating the supplemental log group. If you select
      Execute DDL now
      , the PowerExchange Navigator runs the DDL when you complete the registration. If you do not have the authority to run the DDL, ask your DBA to run it.
    • In the
      Status
      list, select
      Active.
  2. Run the DDL for a creating a supplemental log group for the table, if you did not enable the PowerExchange Navigator to do so at registration completion.
  3. If you use the PowerExchange Logger for Linux, UNIX, and Windows, shut down the PowerExchange Logger and then warm start it.
    The PowerExchange Logger begins capturing change data for the additional table.
  4. In PowerCenter, import the extraction map for the table to create a source definition.
  5. Add the source definition to a new mapping or to an existing mapping.
    If you add the source definition to an existing mapping, you must the stop the workflow first.
  6. Start the workflow that processes the added source table.

0 COMMENTS

We’d like to hear from you!