Data Replication Task Targets
You can replicate source data to database and flat file targets. The type of target affects how the Data Replication task replicates data.
Replicate Data to a Database Target
For a Data Replication task configured with the full load type, the first time you run the task, the task creates the database tables. The Data 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 Data 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 Data Replication task then writes the replicated data to the tables. During subsequent runs, the task performs an upsert operation.
For a Data 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.
Replicate Data to a Flat File Target
When you run a Data Replication task for a flat file target for the first time, the Data Replication task creates the flat files. The Data Replication task then stores the files in the specified directory and writes the replicated data to the files. During subsequent runs, the Data Replication task truncates the file and loads the data.
When the Data Replication task includes flat file targets with multibyte data on Linux, the default locale must be UTF-8.