ETL Process for the Data Deletion DTS Task

  • Article

The Data Deletion DTS task has two ways of deleting data from a Data Warehouse: all data can be deleted or data from particular Web log files can be deleted from the Data Warehouse. Deleting Web log file data can be done at the site level or at the Data Warehouse level. Deleting all data can be done only at the Data Warehouse level.

Web log data can be deleted in two ways: all Web log data can be deleted or only summarized (detail) data can be deleted. The classes, dimensions, and facts deleted by each of these methods are listed in the following sections:

Deleting All Data from Data Warehouse

Deleting Web Log File Data from Data Warehouse

Deleting Web Log File Detail Data from Data Warehouse

Copyright © 2005 Microsoft Corporation.
All rights reserved.