Data warehouse is the collection of data which could be the collection of many or single transaction data source.
Data warehouse is the used for creating the reports for senior management. Then the question comes how come it happens. Data ware house interact with some analytical tool and top of which reports are created. I.e. Data ware house is middle layer between the OLTP and OLAP.
Data warehouse contains the FACT and Dimensions tables.
In computing, a data warehouse or enterprise data warehouse (DW, DWH, or EDW) is a database used for reporting and data analysis. survival-warehouse.com
ReplyDelete