Datawarehousing

Short Questions Answers

Q What is difference between datawarehouse and datawarehousing ?
A Datawarehouse is physical space where historical data is stored where as the process of storing this data in database is called datawarehousing.

Q What are the characteristics of datawarehouse?

Subject- Oriented - should be related to a subject eg sales ,marketting

Integrated- should be intehrated from various sorces after removing inconsistencies

Non Volatile- Nonvolatile means that, once entered into the warehouse, data should not change

Time Variant - All data in the data warehouse is identified with a particular time period.

Q What is Enterprise Data warehouse
A It collects all information about subjects (customers,products,sales,assets, personnel) that span the entire organization