Table of Contents

Search

  1. Preface
  2. Part 1: Introduction
  3. Part 2: PowerExchange Client for PowerCenter (PWXPC)
  4. Part 3: PowerExchange ODBC
  5. Appendix A: PowerExchange Interfaces for PowerCenter Tips
  6. Appendix B: Datatypes and Code Pages
  7. Appendix C: PowerExchange Interfaces for PowerCenter Troubleshooting

PowerExchange Interfaces for PowerCenter

PowerExchange Interfaces for PowerCenter

Enabling Recovery for a CDC Session

Enabling Recovery for a CDC Session

  1. In the session properties, select
    Resume from the last checkpoint
    for the
    Recovery Strategy
    property.
    This recovery strategy is required for the PWXPC and PowerCenter Integration Service to recover CDC sessions.
  2. For the
    Commit Type
    property, enter
    Source
    .
    CDC sessions always use source-based commit processing regardless of the
    Commit Type
    setting.
  3. Clear the
    Commit at End of File
    property.
    After PWXPC shuts down, the PowerCenter Integration Service issues a commit when the session ends. Data that is written to the targets after PWXPC shuts down is not reflected in the restart tokens. Disable this property to ensure that PWXPC issues all commits.

0 COMMENTS

We’d like to hear from you!