Tasks

Back Next

Data subset options

Configure the data subset options on the

Schedule

page. You can view the data subset options if you select multiple source objects.

Configure the following data subset options:

Staging Connection: The connection that the task uses to run the data subset operation.
Source Lookup Batch Size: The number of records to retrieve from the Salesforce source in one SOQL query when the task writes to the target. Uses Salesforce standard API because the standard API limit is higher than the bulk API. Enter a number between 10 and 200 based on the SOQL character limit restriction for Salesforce.
Drop Staging Tables: Drops the staging tables even if there are error rows in the task.; When you configure data subset filters and run the
masking
task, the task runs through the staging, subset computation, target load, and staging drop phases. By default, if there are error rows, the task does not drop the staging tables. You can correct the errors and restart the task. The task resumes from the phase at which it failed. The staged data that is saved in the Secure Agent machine consumes some storage space, and you can choose to drop the staging tables even if there are errors rows present.