Answer Posted / purva
Occasionally, it is necessary to remove large amounts of
data from a data warehouse. A very common scenario is the
rolling window discussed previously, in which older data is
rolled out of the data warehouse to make room for new data.
However, sometimes other data might need to be removed from
a data warehouse. Suppose that a retail company has
previously sold products from Company ABC, and that Company
ABC has subsequently gone out of business. The business
users of the warehouse may decide that they are no longer
interested in seeing any data related to Company ABC, so
this data should be deleted.
This process is data purging.
| Is This Answer Correct ? | 31 Yes | 7 No |
Post New Answer View All Answers
What is the extension of file to save template?
What is difference between query studio and report studio?
After the generation of a report to whom we have to deploy or what we do after the completion of a report?
What is the function of surrogate key in data warehousing?
Whether dimension table can have numeric value?
Where the data cube technology is used?
how much memory space occupied real time project (roughly)?
Explain the versions of reportnet?
How can you import tables from a database?
What is the working process for application.cfm?
Why facts table is useful in representing the data?
What is Operational Data Store?
ware house management system is used?
What is defined as partial backup?
Explain what is ods (operation data source)?
