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 parallel querys and query hints?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is loop in data warehousing?
Theare is a Database In analysis services,How we will specify the fact table.(i.e whether we will create the measure objects for the fact tbl.) or it will reside insde the database.
How to create prompts in report net?
What is a source qualifier?
Explain multivalued dependency?
explain about dirty dimension?
What are non-additive facts in detail?
What is the difference between connected and unconnected stored procedures?
What are snapshots? What are materialized views & where do we use them?
What is the differences between star and snowflake schemas?
what are the major three types of modeling used?
Do you view contain data?
Explain which columns go to the fact table and which columns go the dimension table?
