You can reset a specific version of a data set to a target. Reset a data set to a target to reuse a specific version of test data or to reset test data to an earlier state. You can configure the reset operation based on how you want to replace the test data.
As a best practice, create an index on foreign keys on the target database. During the deletion, the index helps find the child records in the target database. The reset performance improves because the deletion of child records takes less time.
Ensure that you classify the tables in the data set before you perform a reset operation. TDM considers unclassified tables as transactional tables during a reset operation.
If the target is a PWX for NRDB Batch connection, you must manually delete the files in the target before you run the reset task. The reset copies the data in the data set but does not delete the target data before it copies the data.
Open the required version of the data set.
dialog box opens.
Select the target connection from the list of connections.
The source is the test data warehouse. You cannot edit the source. Select the database where you want to replace the data as the target connection.
If the target is a PWX for NRDB Batch connection, enter the target file name.
You cannot configure the reset operation further or enter reset recovery properties if the target is a PWX for NRDB Batch connection.
Configure the settings for the reset operation:
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.
Enter the reset recovery properties.
Backup Recovery Prefix. Enter a prefix for the backup schema. TDM creates a backup schema in the format
Backup Recovery User Name. The name of the schema where you want to store the backup tables.
You cannot enter the reset recovery properties if you choose to truncate tables. TDM does not create a backup when it truncates tables.
Error and Recovery
Optional. You can override the reset settings at the data source level or at the table level.
Select the PowerCenter Integration Service to use for the reset operation. You must select the service that you configured in the Test Data Manager Service.
Select to run the operation or schedule it to run later.