Interested to Buy Any Domain ? << Click Here >> for more details...
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 are data modeling and data mining?
Briefly state different between data ware house & data mart?
Explain clustering algorithm?
What is Star Schema?
Compare and contrast aggregates & indexes
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
Explain in detail abt measure objects? And what is the use of it? How to create it?
What is application.cfm?
Difference between e-r modeling and dimentional modeling?
What we will do with the universe for faster process?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Where we use surrogate key explain with example?
What are the reasons to use a chameleon method in data warehousing?
what are the other factors of the database on which the loading performance depend?
What is cfapplication tag?
