Load Types

The load type determines the type of operation to use when the Data 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 Data Replication task runs, it performs a full load, replicating all rows of the source. For each subsequent run, the Data Replication task performs an incremental load. In an incremental load, the Data 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 Data Replication task always performs an incremental load with this load type. The first time the Data Replication task runs, the Data Replication task processes rows created or modified after a specified point in time. For each subsequent run, the Data 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 Data 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 Informatica Cloud Salesforce Connector Guide.

Full Load

For a full load, the Data Replication task replicates the data for all rows of the source objects in the task. Each time the task runs, the Data 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 Data Replication task uses a database source.

•A Salesforce object in the Data Replication task is configured to be nonreplicateable within Salesforce.

If you run an incremental load on a Data Replication task that contains nonreplicateable objects, the Data Replication task runs a full load on the object. Contact the Salesforce administrator to get a list of replicateable Salesforce objects.

•The datatype of a Salesforce field changed.

If the Data Replication task detects a datatype change, you might need to reset the target table to create a table that matches the updated Salesforce object. Then run the Data Replication task with full load to reload the data for all Salesforce objects included in the Data 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 datatypes are not compatible. For more information about the AutoAlterColumnType property, see the IInformatica Cloud Salesforce Connector GuideSalesforce Connection Properties section.