Process Overview

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.