When the PowerCenter Integration Service runs a continuous CDC session, it reads all records in the source object and passes them to the next transformation as rows flagged for insert. After the PowerCenter Integration Service reads all source data, the CDC time limit and flush interval begin.

After the flush interval ends, the PowerCenter Integration Service completes the following tasks to capture changed data for a continuous CDC session:

After the PowerCenter Integration Service finishes reading all changed data, the flush interval starts again. The PowerCenter Integration Service stops reading from Salesforce when the CDC time limit ends.

When you configure the session to capture changed data and use source-based commits, the PowerCenter Integration Service commits data to the target based on the source-based commit interval and the flush interval.

For example, you set the CDC time limit to 4,000 seconds, the flush interval to 300 seconds, and the source-based commit interval to 1,000 rows. After the PowerCenter Integration Service reads all the source data, the flush interval begins. The PowerCenter Integration Service captures changed data and commits rows to the target after reading 1,000 rows from the source and after each 300 second flush interval. The PowerCenter Integration Service stops reading from Salesforce after 4,000 seconds.

When you configure the session to use target-based commits, the PowerCenter Integration Service runs the session based on source-based commits. Also, it only commits rows to the target based on the flush interval. It does not commit rows to the target based on the commit interval.