If you replicate multiple source objects with the same names from different

replication

tasks to the same database user account, the

replication

task creates one target table, and overwrites the table data each time you replicate one of the objects. If you run a full load, it overwrites the entire table. If you run an incremental load, it overwrites the changed rows.

To avoid overwriting tables, use a different target table name prefix for each

replication

task.