A data warehouse (DW) is a database used for reporting. The data is offloaded from the operational systems for reporting. The data may pass through an operational data store for additional operations before it is used in the DW for reporting.
data warehousing is a database used for reporting.the data is stored in warehouse and uploaded from the operational system.dw maintains its working in three layers as staging ,integration,access.