Table of Contents

Search

  1. Preface
  2. Introduction to Test Data Management
  3. Test Data Manager
  4. Projects
  5. Policies
  6. Data Discovery
  7. Data Subset
  8. Data Masking
  9. Data Masking Techniques and Parameters
  10. Data Generation
  11. Data Generation Techniques and Parameters
  12. Working with Test Data Warehouse
  13. Plans and Workflows
  14. Monitor
  15. Reports
  16. ilmcmd
  17. tdwcmd
  18. tdwquery
  19. Data Type Reference
  20. Data Type Reference for Test Data Warehouse
  21. Glossary

Resetting a Data Set

Resetting a Data Set

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.
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.
  1. Open the required version of the data set.
  2. Click
    Actions
    Reset
    .
    The
    Reset
    dialog box opens.
  3. 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.
  4. 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.
  5. Enter the reset recovery properties.
    • Backup Recovery Prefix. Enter a prefix for the backup schema. TDM creates a backup schema in the format
      <prefix>_t<ablename>
      .
    • 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.
  6. Edit the
    Error and Recovery
    and
    Advanced Settings
    as required.
  7. Click
    Next
    .
  8. Optional. You can override the reset settings at the data source level or at the table level.
  9. 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.
  10. Select to run the operation or schedule it to run later.
  11. Click
    OK
    .
You can view the job log messages in the
Monitor
tab.