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

Commit Processing for CDC Sessions

Commit Processing for CDC Sessions

The PowerCenter Integration Service, in conjunction with PWXPC, commits data to the target based on commit connection attributes and the commit type.
By default, the
Commit Type
property on the session Properties tab specifies
Target
. For CDC sessions, the Integration Service always uses source-based commit processing. When you run a CDC session that specifies target-based commit processing, the PowerCenter Integration Service automatically changes the commit type to source-based and writes message WRT_8226 in the session log.
For CDC sessions, PWXPC ignores the
Commit Interval
attribute. To control commit processing, configure attributes on the PWX CDC Change and Real Time application connections.

0 COMMENTS

We’d like to hear from you!