By default, the

Commit Type

session property specifies

Target

for target-based commit processing. However, the PowerCenter Integration Service always uses source-based commit processing for CDC sessions. Change the commit type to

Source

. If you retain the default value and run a CDC session, the PowerCenter Integration Service automatically uses source-based commit processing and writes message WRT_8226 in the session log. You do not need to set the

Commit Interval

session property because PWXPC ignores it.

To control when commits occur, configure committment control attributes on the PWX CDC Change and Real Time application connections.

The following table describes these connection attributes:

PWXPC flushes the data buffer to commit change data to the targets when one of the following thresholds is met, whichever one is first:

If you specify

Minimum Rows Per commit

, this threshold must also be met before a commit occur.

After PWXPC commits the change data, it resets the UOW count, the maximum and minimum rows per commit, and the real-time flush latency timer. PWXPC continues to read change data. Whenever one of the commitment control thresholds is met, PWXPC commits change data to the targets. Commit processing continues until the CDC session is stopped, ends, or terminates abnormally. When the PWXPC CDC reader ends normally, PWXPC issues a final commit to flush all complete, buffered UOWs and their final restart tokens to the targets. Prior to ending, the PWXPC CDC reader writes the following message to the session log: