During the course of testing, the test data might change. You might want to reset the test data in a target with a version of the data set from the test data mart.
For example, you are responsible for testing certain features of an application. You create test data to use in the test cases that you run. Before you use the data in test cases, you save the data as a data set version in the test data mart. When you complete tests on some features, the data might change or get corrupted. You might require the original test data to run the rest of the test cases. You can replace the data in the test system with the data set version in the test data mart. Perform a reset operation from the data set version to a target. Use the test system as the target.
You can configure a reset operation to delete the target data and replace it with the data set version. In this case, the reset operation restores the target to the exact same state as the data set version. Perform this reset operation if testers do not share the tables. You do not need records that exist in the target and not in the data set version.
You might want to retain data in the target that is not in the data set version. Consider a case where multiple testers use the test data. You need the first 100 records in a Customer table. You create a data set version that contains the first 100 records of the Customer table. After running a few tests, you want to replace the test data with the data set version. You must configure the reset operation to ensure that the additional data in the target remains untouched when you reset the data in the data set version.
In reset operations that selectively delete and load data, TDM runs an SQL script to create a backup of the deleted data in the target.
You can select the required configuration when you configure the reset operation.