What is Data warehouse

A system that

§ Retrieves and consolidates data periodically from the source system into a dimensional or normalized data store.

§Keeps years of history and is queried for business intelligence.

§Needs an Extract, Transform  and Load (ETL) tool in order to build data warehouse and refresh the data