InterviewSolution
| 1. |
What do you mean by data purging in the context of data warehousing? |
|
Answer» Data PURGING is a term that DESCRIBES techniques for permanently erasing and removing data from a storage space. Data purging, which is typically contrasted with data deletion, involves a variety of procedures and techniques. Purging removes data permanently and frees up memory or storage space for other purposes, whereas deletion is commonly THOUGHT of as a temporary preference. Automatic data purging features are one of the methods for data cleansing in database administration. Some Microsoft products, for example, feature an automatic purge strategy that uses a circular buffer mechanism, in which older data is purged to create room for fresh data. Administrators must manually REMOVE data from the database in other CIRCUMSTANCES. |
|