Truncate Tables. Select this option if you want to completely replace the target connection with data from the data set. TDM deletes all data in the target, and copies the data in the data set to the target. TDM disables constraints and indexes when it performs this operation.
Disable Constraints and Indexes. Select this option if you want to disable constraints and indexes during the reset operation.
Upsert in Transactional Tables. Select this option if you want to perform an upsert on transactional tables instead of an insert. If the parent records of records in the data set have changed to point to a different parent in the target, the insert might fail. The reset operation fails if the insert fails. Select this option and perform an upsert on transactional tables.