Why Data Ware Housing

Data ware house - Data Base for Analysis and Reporting. 

Why we need Data ware Housing? 

Data ware house is a database for Analysis and Reporting not for transaction processing but we can include from other data sources. In organizations,to find the current status,forecast the values and add the forecast values to the database.Data ware house maintains the historical data of database(i.e.,Transaction data).

Data ware housing process

Data ware Housing is a process extracting data from Database(OLTP-online Transaction process) system and load the data into Dataware house(OLAP-Online Analytical processing).We can also add the forecast values to the database.