Delete Staging Tables Log File Enhancements

With this enhancement, when more than 500 data sets are deleted using the Delete Stage Table Data or Delete Spreadsheet Stage Table Data task, the process log file will now capture the total count of deleted data sets along with the SQL statement to retrieve the details of all purged data. For deletions involving 500 data sets or less, the log file will continue to record the full details of each deleted data set as before.

As a result, the overall performance is improved when deleting large volumes of data sets, since detailed data is no longer written to the log file.

Steps to Enable

You don't need to do anything to enable this feature.

Key Resources

For more information on deleting HDL and HSDL stage table data, refer: Overview of Maintaining the Stage Tables