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 type 2 version dimension?
What is load manager?
What is many-to-many dimensional model in datawarehousing ?
Explain what are the tasks that loadmanger process will do?
how much memory space occupied real time project (roughly)?
What is metadata in context of a datawarehouse?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
What is pre-emptive and non-pre-emptive?
How can you communicate with web server (apache or iis) from coldfusion?
Hi, i want to do certification in datawarehouse?? which certification is best in current trend?? pls mention the cost also if u can....
Define data warehouse?
Explain reference cursor?
What are the advantages and disadvantages of reporting directly against the database?
Explain grouped cross tab?
What is drilling across?