HANDLING DATA, METADATA AND DESIGN FOR GLOBAL DATA WAREHOUSE

Abstract

Data ware house modeling is a complicat e d task, which involves knowled g e of business process, as well as familiarity with operatio n al information system structure and beha v ior. While it is universally recognized that a DW leans on multi dimensional model, there is suggested to contract a data ware house conce p tual model, My analysis of these methods indicate that they are limited in their applic a bility to model large scale systems, as they require acqu a intance with the business process and ability to s elect relevant transaction al eliminate the technic a l and reporting difficulties experienced with the classic star schemes and snow flake. The objective of Meta data strategy is to provide a blueprint that will enable efficient stronger , mainten a nce, and delivery of timely and accurate business and technic a l Meta data of the organiz a tion in buildi n g a ro b ust data warehouse environme n t ,meta data is considered to be a critical success factor .This work will address meta data requirement and a proposed solution for effective metadata mana g ement and deploy m ent /delivery at organiz a tion .The purpose of data quality method o logy is to validate the quality of specific business applic a tion includi n g the source of these business applic a tion and the process that feed the business applic a tion of the EDW environme n t applic a tion are worthless .Business applic a tion vend o rs have great produ c ts to sell ,offering simplified access to complex comput a tion models and enormo u s stores of corporate data, yet they often deliver below expectati o ns. This work will help to overcome t h is limitation.