In a typical database environment, the database administrators assign a fixed set of table space to the Workschema. Since ETL Validator loads the source and target data into the Workschema, the tables might run out of space. To overcome this problem, ETL Validator allows purging of data accumulated in the workschema tables. In the Purge view, you will find test cases which are currently in use and which were deleted. The deleted ones are flagged as True and those in use are flagged as False. To purge data, you can either do it instantly or create a recurring schedule.

Calculate Memory Occupied

Before you want to purge test cases instantly, you can check how much memory the test cases have occupied. 

To calculate the memory, select the test cases and click Calculate Memory Occupied. The ETL Validator Server calculates it in the background and displays the size for the selected test cases in the Memory Occupied (MB) column.

Purge Run History and Benchmark

You can purge run history and benchmark data of test cases instantly at any time you wish to. To do so, select the folder containing the test cases you wish to purge, select the test cases, and click Purge Run History and Benchmark.

Create a Schedule for Purge

You can create a purge schedule to clean up unwanted test case data on a recurring basis. 

To create a schedule for purging,

  1. Click Schedule.
  2. Select test cases in the tree available on the right side.
  3. Select Start Date and End Date for Schedule Time.
  4. Select any one of the Recurrence Pattern.
    • Run Once
    • Run Daily
    • Run Weekly
    • Run Monthly
    • Repeat Every
  5. Select the following Purge Options:
    • Purge only that were last Run before
    • Purge Method
      • Purge All Testcases. All test cases available in each of the test folder will be purged.
      • Purge only Selected Test Folders. Test cases that are part of the selected test folders will be purged.
  6. Click Save.

© Datagaps. All rights reserved.
Send feedback on this topic to Datagaps Support