Date Added: Feb 2014
A data warehouse is a data repository, containing historical data, prepared for analysis and supporting decision making process. Data warehouses are in use for more than a decade but companies are still finding it difficult to decide on the approach they should take for successful implementation. Data warehouse architecture plays a major role the successful construction of data warehouse. This paper proposes an approach of constructing local data marts at source and integrating them at enterprise level by creating physical data marts to give global view for the analysis.