Process Overview
May 21, 2019
|By Thomas Pryce
Created On
byThomas Pryce
< Back
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:
- 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.
- PREPENV: If you drop the tables, you will need to re-register tables before performing the next Subset.
- TRUNCATE: Deletes data from the Target Database or Schema.
- BUILDMODEL: Creates the rules to drive the Advanced Subset, based on the Control Spreadsheet.
- SUBSET: Writes the new Data Subset to the Staging Database.
Table of Contents