Developer Workflow Guide

10.5.2
- 10.5.3
- 10.5
- 10.4.1
- 10.4.0

Back Next

Configure the Mapping to Remove Target Rows

If the mapping writes to a file or a table that does not contain data that you need to keep, you can configure the mapping to remove all data from the target file or table. If the mapping writes to a shared table that a Human task does not read, you can configure the mapping to run an SQL command to remove the rows written in the original run.

Configure the mapping to use one of the following methods to remove target rows:

Truncate a flat file target.: If you can remove all data from the target file, configure the mapping to truncate the target file before it writes to the file.
Truncate a relational target table.: If you can remove all data from the target table, configure the mapping to truncate the target before it loads data.
Run an SQL command on a relational target table.: If you need to keep some of the data in the target table, write an SQL command that the Data Integration Service runs to remove the rows written in the interrupted mapping run before it reads the source. For example, if the mapping writes sales data to a table that multiple departments share, write an SQL command that deletes all rows written for the Sales department. Or, if the mapping runs once daily, write an SQL command that deletes all rows written on the current date.