a2zinterviews

9.	What are the types of data warehouses?
	There are mainly three type of Data Warehouse. Enterprise Data Warehouse Operational data store Data Mart. Enterprise Data Warehouse provide a control Data Base for decision support through out the enterprise. Operational data store has a broad enterprise under scope but unlike a real enterprise DW. Data is refreshed in rare real time and used for routine business activity. Data Mart is a sub part of Data Warehouse. It support a particular reason or it is design for particular lines of business such as sells, marketing or finance, or in any organization documents of a particular department will be data mart.
	Discuss Your Name Your Email-ID Your Answer

10.	What is the difference between database and data warehouse?
	A database is a collection of related data and a database system is a database and database software together. A data warehouse is also a collection of information as well as a supporting system.
	Discuss Your Name Your Email-ID Your Answer

11.	What are the benefits of data warehousing?
	Historical information for comparative and competitive analysis. Enhanced data quality and completeness Supplementing disaster recovery plans with another data backup source. Integrate external as well as internal data Support strategic and long-term business planning Support day to day tactical decisions Enable insight into business trends and business opportunities Organize and store historical data needed for analysis Make available historical data, extending over many years, which enables trend analysis Provide more accurate and complete information Improve knowledge about the business Enable cost effective decision making Provide easy access for end users.
	Discuss Your Name Your Email-ID Your Answer

12.	What is the difference between Data warehouse and traditional database?
	Discuss Your Name Your Email-ID Your Answer