The load type determines the type of operation to use when the replication task replicates data from the source to the target.
Use one of the following load types when you replicate data:
Incremental loads after initial full load
The first time the replication task runs, it performs a full load, replicating all rows of the source. For each subsequent run, the replication task performs an incremental load. In an incremental load, the replication task uses an upsert operation to replicate rows that changed since the last time the task ran. You can specify this load type when the task uses a Salesforce source and a database target.
Incremental loads after initial partial load
The replication task always performs an incremental load with this load type. The first time the replication task runs, the replication task processes rows created or modified after a specified point in time. For each subsequent run, the replication task replicates rows that changed since the last time the task ran. You can specify this load type when the task uses a Salesforce source and a database target.
Full load each run
The replication task replicates all rows of the source objects in the task during each run. You can specify this load type when the task uses a Salesforce or database source and a database or flat file target.
For information about incremental load, see the help for Salesforce Connector.
Full load
For a full load, the replication task replicates the data for all rows of the source objects in the task. Each time the task runs, the replication task truncates the target database tables or flat file and performs a full data refresh from the source.
Run a full load in the following situations:
•The replication task uses a database source.
•A Salesforce object in the replication task is configured to be nonreplicateable within Salesforce.
If you run an incremental load on a replication task that contains nonreplicateable objects, the replication task runs a full load on the object. Contact the Salesforce administrator to get a list of replicateable Salesforce objects.
•The data type of a Salesforce field changed.
If the replication task detects a data type change, you might need to reset the target table to create a table that matches the updated Salesforce object. Then run the replication task with full load to reload the data for all Salesforce objects included in the replication task. Alternatively, you can set the AutoAlterColumnType custom configuration property so that the target table column updates to match the Salesforce object. The AutoAlterColumnType property does not apply in certain situations, such as when the source and target data types are not compatible. For more information about the AutoAlterColumnType property, see the help for Salesforce Connector.