Once you have updated your Control Spreadsheet, you can run the actions involved in an Advanced Subset.

The Actions typically involved in running an iterative Subset are:

  1. DROP: Drops the tables registered by the TABLES action and deletes the data in your Target Database. You will only run this if something has gone wrong in a Subset, and you want to create a wholly new Data Subset.

    1. PREPENV: If you drop the tables, you will need to re-register tables before performing the next Subset.

  2. TRUNCATE: Deletes data from the Target Database or Schema.

  3. BUILDMODEL: Creates the rules to drive the Advanced Subset, based on the Control Spreadsheet.

  4. SUBSET: Writes the new Data Subset to the Staging Database.