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. Data Sets
  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. Data Type Reference for Hadoop
  22. Glossary

Resetting a Data Set Version

Resetting a Data Set Version

You can reset a specific version of a data set to a target. Reset a data set version 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 version before you perform a reset operation. TDM considers unclassified tables as transactional tables during a reset operation.
  1. Open the required data set version.
  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 mart. 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 version. TDM deletes all data in the target, and copies the data set version 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 version 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_tablename
      .
    • 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.