What is Data Warehouse:
The First Data Warehousing System is implemented in 1987 by Inmon.
Data warehouse is a relational database that is designed for querying and analyzing the business but not for transaction processing.It usually contains historical data derived from transactional data (different source systems).
Data Warehouse is nothing but collection of data from different types of source systems and we are converting that data into organised format for the purpose of doing analysis to take the decision.
Data Warehouse is not a technology, the combination of multiple technologies(Reporting tool,ETL Tools,DB)
Depending on Requirement to design the DWH
Data Warehouse is not a technology, the combination of multiple technologies(Reporting tool,ETL Tools,DB)
Depending on Requirement to design the DWH
