DATA WAREHOUSE IMPLEMENTATION
CHAPTER1 CHAPTER2 CHAPTER 3 DATA WAREHOUSE IMPLEMENTATION WHAT? Data warehouse implementation is a series of activities that are essential to create a fully functioning data warehouse after classifying, analyzing and designing the data warehouse with respect to the requirements provided by the client. Various phases of data warehouse implementation are: - (i) Planning (ii) Data Gathering (iii) Data Analysis (iv) Business Actions Data warehouses need few important components to defined while designing implementation of system, such as data marts, OLTP/OLAP, ETL, meta data etc. WHY? To identify & store the data in effective manner. It can help in making decision based on strong data analysis. It stores data from various sources with different formats & with help of ETL tools convert this data into standard format. HOW? The processes are as follow: - Planning: - It is one of most important steps of process. It helps in ...