This recovery strategy is required for the PWXPC and PowerCenter Integration Service to recover CDC sessions.
For the
Commit Type
property, enter
Source
.
CDC sessions always use source-based commit processing regardless of the
Commit Type
setting.
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.