Data Warehousing is a relational database which is used to store large volumes of data for analyzing business but not for business transaction processing
A data warehouse is a subject oriented, integrated, non-volatile, time variant database in support of management decision-W.H.Inmon
Tables in DWH has to be concentrated on the subject
Ex: Products, Customers, Sales
When we bring data from multiple sources, we need to make sure that the data has to be in a uniform format
In DWH data is for read-only.
To compare business across time
Get Updates on Tech posts, Interview & Certification questions and training schedules