Load Types
When you configure a Data Replication task, you specify the load type to use. The load type determines the type of operation to use when the Data Replication task replicates data from the source to the target. You can specify an incremental load type when the task uses a Salesforce source.
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 with this load type, it performs a full refresh, replicating all rows of the source. For each subsequent run, the Data Replication task performs an incremental run. In an incremental run, the Data Replication task uses an upsert operation to replicate rows that changed since the last time the task ran.
- Incremental loads after initial partial load
- The Data Replication task always performs an incremental run 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.
- Full load each run
- The Data Replication task performs a full refresh and replicates all rows of the source objects in the task.
For information about incremental load, see Informatica Cloud Salesforce Connector User 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 data type of a Salesforce field changed.
If the Data 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 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, for example, when the source and target data types are not compatible. For more information about the AutoAlterColumnType property, see the Salesforce Connector Guide.