Perform the following steps to enable PK Chunking:
- Create a task to read data from a Salesforce source or edit an existing task that reads data from a Salesforce source.
- On the Schedule tab, under Advanced Salesforce Options, select Bulk API from the Salesforce API drop-down. PK Chunking...
- Select the checkbox to enable PK Chunking and configure the following...
How do I enable PK chunking for a bulk query?
Use the primary key (PK) Chunking request header to enable automatic PK chunking for a bulk query job. PK chunking splits bulk queries on large tables into chunks based on the record IDs, or primary keys, of the queried records.
What is PK chunking in Salesforce?
If PK Chunking is enabled, then Salesforce internally generates separate batches based on the PK Chunking size given.
What is PK chunking in Informatica cloud?
In Informatica Cloud, it is available for bulk API tasks which use Salesforce API version 32 or above; and is enabled and configured on the schedule tab of the task. If PK Chunking is enabled, then Salesforce internally generates separate batches based on the PK Chunking size given.
What is pkpk chunking and how does it work?
PK chunking is designed for extracting data from entire tables, but you can also use it for filtered queries. Because records could be filtered from each query’s results, the number of returned results for each chunk can be less than the chunk size.
See more
How do I enable PK chunking in Iics?
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. Select the checkbox to enable PK Chunking and configure the following properties: a.
What is PK in Salesforce?
The Primary Key lets Salesforce CDP identify uniquely a record. As records are loaded into the data source object (DSO), it can either update or create a record. Because the primary key is the basis for inserting versus updating, you must define the primary key correctly.
What is PK chunking in Informatica Cloud?
PK Chunking is a new feature enabled by Salesforce for its bulk API. In Informatica Cloud, it is available for bulk API tasks which use Salesforce API version 32 or above; and is enabled and configured on the schedule tab of the task.
What is Salesforce PK chunking?
Use the primary key (PK) chunking request header to enable automatic PK chunking for a bulk query job. PK chunking splits bulk queries on large tables into chunks based on the record IDs, or primary keys, of the queried records.
What is chunk in Salesforce?
PK chunking splits the bulk queries into sections from the record IDs, or primary keys, of the queried records. Each chunk is processed as a separate batch that counts toward your daily batch limit, and you must download each batch's results separately.
Check the Status of the Job and Batch
Using a command-line window, execute this cURL command to check the job status.
Get the IDs of the Remaining Batches
Using the command-line window, execute this cURL command to retrieve the remaining batches.