Truncating the Existing Data Subset

Search Knowledge Base by Keyword

< Back

If you have not used the DROP Action, you will first need to delete the data from your Target Database to perform an updated Subset. This is performed using the TRUNCATE action.

To run TRUNCATE, first open your re-usable .cmd script in a text editor.

If you have already configured a .cmd script for one Subset Action and wish to edit and re-use that script, you should only need to specify “TRUNCATE” for  -parAction=””:

Data Subsetting

Otherwise, configure all mandatory parameters in the .cmd script.

You can also specify optional parameters at this stage.

Make sure your Control Spreadsheet, the Subset Report, and any Log Files are closed.

Run the script to delete the data from your Target Database

Check your Target Database to make sure the data has been deleted.

Next, check the Log File and Subset Report at this stage, to check that the Actions have performed correctly.