Data Warehouse - Basics Fundamental Notes - Part1
Data warehouse which is build on RDMS is used for analyze the data and based on the nature of data and the analysis, people take the decisions. The objective is to bring intelligence analysis which lead to make the predictive analysis call right. Following are few fundamental notes on data warehouse. Now a days, the Data Lake is being used for Big Data analysis purpose and not limited only in RDMS stored area. In particular, there are three key factors are exist in data warehouse world , and they are three V's - Volume , Velocity , and Variety . In data warehouse, not only structured data maintained or analysis, the data warehouse system should able to handle unstructured data like video, audio, images as well. Centralize data warehouse using Single RDMS. Keep a note that data warehouse is NOT as Data mart. Dependent DataMart variation with Corporate Information Factory(CIF). There are four rule of data warehouse Integrated Subject Oriented Time Variant Non Volatile ETL(Extract,