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
Can you brief about the Data warehouse project you worked on?
for data loading in oracle, what are conventional loading , what are conventional loading and direct-path loading?
Explain what is batch and describe about types of batches?
What are the types of dimensional modeling?
Explain when do we analyze the tables? How do we do it?
What are the difference between snow flake and star schema? What are situations where snow flake schema is better than star schema to use and when the oppositeis true?
Can you describe me a problem you faced when you were trying to load data from R3 system and another system outside sap systems?
What is vldb(very large databases)?
What is called data cleaning?
Why fact table is in a normal form?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What is metadata in context of a datawarehouse?
Explain dimension table ?
Explain how many ways you create ports?
What is an er diagram?
