Data warehouse presentation evaluation Essay Example | Topics and Well Written Essays - 500 words

information w arehouse presentation evaluation - Essay ExampleOn the downside, a top-down approach whitethorn take longer and cost more to deploy than other approaches, especially in the initial increments. (para.8-11)bottom-up access uses the bus structure that contains all the common elements that are used by data marts such as conformed dimensions, measures etc defined for the enterprise as a whole. The major benefit of a Bottom-Up Approach is user-friendly, flexible data structure using dimensional, star abstract models. It also delivers value rapidly. One enigma is that it requires organizations to enforce the use of standard dimensions and facts to ensure integration and deliver a single version of the truth. (Eckerson para.12-18) hybridization Approach aims to harness the speed and user orientation of the Bottom-Up Approach to the integration of the Top-Down Approach. By Eckerson (para.19-25), Hybrid Approach recommends spending about two weeks developing an enterprise mo del in troika normal form before developing the first data mart. The first several data marts are also designed in third normal form but deployed using star schema physical models.Federated Appro