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.
Insert in Master Tables. Select this option to perform an insert on master tables instead of an upsert. Select this option if you are sure that no records from the data set exist in the target. Instead of first checking if any records exist and need to be updated, the reset directly inserts all records from the data set into the target. To use this option, all tables in the data set must be classified as master tables.