task configured with the full load type, the first time you run the task, the task creates the database tables. The
replication
task then writes the replicated data to the tables. During subsequent runs, the task truncates the database tables and then writes the source data to the tables.
For a
replication
task configured with the incremental load after initial full load type, the first time you run the task, the task creates the database tables. The
replication
task then writes the replicated data to the tables. During subsequent runs, the task performs an upsert operation.
For a
replication
task configured with the incremental load after initial partial load, the first time you run the task and for subsequent runs, the task performs an upsert to replicate source data from the specified period in time.