During the course of testing, the test data might change. You might want to reset the data in a test environment with a version of the data set from the test data warehouse.

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, you save the data as a data set in the test data warehouse. 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 in the test data warehouse. Perform a reset operation from the data set 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 in the data set. In this case, the reset operation restores the target data to the exact same state as the data set. 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.

You might want to retain data in the target that is not in the data set. 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 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. 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.

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.