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. Analyzing Test Data with Data Coverage
  14. Plans and Workflows
  15. Monitor
  16. Reports
  17. ilmcmd
  18. tdwcmd
  19. tdwquery
  20. Data Type Reference
  21. Data Type Reference for Test Data Warehouse
  22. Data Type Reference for Hadoop
  23. Glossary

Reset Without Truncate Tables Process Flow

Reset Without Truncate Tables Process Flow

You can perform a reset operation without truncating the tables.
TDM performs the following tasks when you perform a reset operation and do not select the truncate tables option:
  1. Identifies records for deletion from transactional tables that have child tables.
  2. If there are no records to delete, TDM skips this step. If records for deletion exist, TDM performs the following tasks.
    1. Creates staging tables for the identified records and stages the keys.
    2. Identifies top-most transactional tables in the data set.
    3. For each record in a top-most transactional table in the target, if a record exists in the data set, TDM marks the record in the staging table.
    4. Runs an SQL script to cascade mark records in the staged tables for deletion. If a parent record is marked for deletion, TDM marks the child record for deletion.
    5. Checks if recovery is enabled for the reset operation and that the user name and prefix information are available.
    6. If the recovery option is enabled and the prefix information provided, TDM performs the following tasks. If the recovery option is not enabled, TDM skips this step.
      1. Creates temporary tables in the backup schema and then moves records from the staging area to the backup schema.
      2. Stores a backup of all records marked for deletion in the backup tables in the backup schema. TDM runs an SQL script to back up the tables and uses the naming convention
        <prefix>_<targetname>
        .
  3. Checks if the
    Disable Constraints and Indexes
    option is enabled. If the option is enabled, the reset operation performs the following steps:
    1. Disables the constraints and indexes.
    2. Deletes marked records from the target. TDM reads the marked records from the staging tables.
    3. Moves data from the data set to the target. TDM processes multiple tables in parallel because the constraints and indexes are disabled.
    4. Enables the constraints and indexes.
      If the option is not enabled, the reset operation performs the following steps:
    1. Deletes marked records from the target. TDM reads the marked records from the staging tables.
    2. Moves data from the data set to the target. TDM processes the tables according to constraints because the constraints exist.
  4. Deletes the temporary tables, if created.
  5. Deletes the staging tables, if created.
  6. If the reset operation is successful, TDM deletes the backup tables. If the reset operation is not successful, TDM retains the backup tables and displays an error message.