You can configure a

data transfer

task to truncate a database target table before writing new data to the table when the task uses an Insert operation. By default,

Data Integration

inserts new rows without truncating the target table.