Tasks

Back Next

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

Load types

Download Guide

Watch

Comments

Cloud Data Integration Homepage