what is the importance of data warehouse database?
A Data Warehouse Provides Historical Intelligence A data warehouse stores large amounts of historical data so you can analyze different time periods and trends in order to make future predictions. Such data typically cannot be stored in a transactional database or used to generate reports from a transactional system.