Skip Ribbon Commands
Skip to main content
Navigate Up
Sign In

Quick Launch

Average Rating:

facebook Twitter
Email
Print Bookmark Alert me when this article is updated

Feedback

HOW TO: Enable PK Chunking for a Salesforce source object in Data Integration
Solution
When you use the Bulk API to extract data from Salesforce, you can enable primary key chunking to increase performance when you extract data from large tables.
The PK Chunking option is available in Synchronization tasks, Replication tasks, and Mapping tasks. To enable this feature, you must use Salesforce API version 32.0 or above in the service URL when you configure the Salesforce connection for the task.

Perform the following steps to enable PK Chunking:
  1. Create a task to read data from a Salesforce source or edit an existing task that reads data from a Salesforce source.
  2. On the Schedule tab, under Advanced Salesforce Options, select Bulk API from the Salesforce API drop-down. 
    PK Chunking option is available under Advanced Source Properties
  3. Select the checkbox to enable PK Chunking and configure the following properties:
        a. PK Chunking Size: Size of each chunk of the data set. The default chunk size is 100000.
        b. PK Chunking startRow ID: The Bulk API splits the data set into multiple chunks based on the record ID and creates extract queries for each chunk.

    SFDC02.PNG
More Information
Reference
Applies To
Product: Cloud Data Integration
Problem Type:
User Type: Architect; Developer
Project Phase:
Product Version:
Database:
Operating System:
Other Software:
Attachments
Last Modified Date:9/13/2018 9:32 PMID:548957
People who viewed this also viewed

Feedback

Did this KB document help you?



What can we do to improve this information (2000 or fewer characters)