The PowerCenter Integration Service commits data based on the number of source rows. The commit point is the commit interval you configure in the session properties. The PowerCenter Integration Service commits data to the target based on the number of rows from some active sources in a target load order group. These rows are referred to as source rows.
The PowerCenter Integration Service commits messages based on the commit interval and the flush latency interval. For example, you use five seconds as the flush latency interval and you set the source-based commit interval to 1,000 messages. The PowerCenter Integration Service sends messages to the target after receiving 1,000 messages from the source and after each five second flush latency interval.
The PowerCenter Integration Service writes a message to the session log stating that source-based commit is disabled for the session in the following situations:
You run a session with an MQ source and an XML associated source definition with more than one group in the mapping.
You use a source-based commit and configure the filter condition to use the FlushLatency(n) function.