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