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.