Overview of Post-Subset Actions

Search Knowledge Base by Keyword

< Back

Running the SUBSET Action will Subset the data based on the Subset Rules in your Configuration Sheet. However, you might want to perform addition actions on your data.

The post-Subset actions available when using Test Data Automation are:

  1. ADDPKEYS: Adds Primary Key Constraints to the Staging Database.
  2. ADDFKEYS: Adds Foreign Key constraints.
  3. VALIDATEPKEYS: Checks that all Primary Keys are unique.
  4. VALIDATEFKEYS: Checks whether Foreign Keys can be added to the data.
  5. DELETEORPHANS: Removes rows that do not fulfil Foreign Key constraints. This is useful if FoundCriteria have been specified.
  6. Data edits: Various actions will edit the resultant data Subset:
    1. DROPFKEYS: Drops Foreign Keys.
    2. DROPPKEYS: Drops Primary Keys.
    3. TRUNCATE: Deletes the data from the target Database or Schema, allowing you to subset iteratively.
    4. DROP: Drops the tables created by the PREPENV Action.

Instructions on running each action are provided below.