Target latency is the total time that PWXPC takes to extract change data from the change stream and that the PowerCenter Integration Service takes to apply that data to the targets. If this processing occurs quickly, target latency is low.

The values that you use for the commit control attributes affect target latency. You must balance target latency requirements with resource consumption on the PowerCenter Integration Service machine and the target databases.

Lower target latency results in higher resource consumption because the PowerCenter Integration Service must flush the change data more frequently and the target databases must process more commit requests.

The following default values for commit control attributes result in the lowest latency:

These values can decrease target latency because PWXPC commits changes after each UOW or on UOW boundaries. However, these values also cause the highest resource consumption on the source system, the Integration Service machine, and the target databases. Or these values might decrease throughput because change data flushes too frequently for the PowerCenter Integration Service or the target databases to handle.

To lower resource consumption and potentially increase throughput for CDC sessions, specify a value greater than the default value for only one of the following attributes:

Disable the unused attributes.