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 is the use of dimensional modeling in data warehousing?
What is defined as partial backup?
Explain the difference between view and materialized view?
What is conformed fact?
Suppose we want to display zero when null values coming to report how can we do that?
Explain conformed fact?
What are the data marts?
What is what are semi-additive and factless facts and in which scenario will you use such kinds of fact tables?
Code the tables statement to produce a multi-level frequency?
Why should you put your data warehouse on a different system than your oltp system?
Suggest a good author for hyperion in data warehousing?
What are the different types of datawarehosuing?
What is a source qualifier?
What are cluster analysis in data warehousing?
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.
