May 22, 2011

Reasons for creating a Data mart

        To give users access to the data they need to analyze most often
        To provide data in a form that matches the collective view of the data by a group of users in a department or business function
        To improve end-user response time due to the reduction in the volume of data to be accessed
        To provide appropriately structured data as ditated by the requirements of end-user access tools
        Normally use less data so tasks such as data cleansing, loading, transformation, and integration are far easier, and hence implementing and setting up a data mart is simpler than establishing a corporate data warehouse
        The cost of implementing data marts is normally less than that required to establish a data warehouse
        The potential users of a data mart are more clearly defined and can be more easily targeted to obtain support for a data mart project rather than a corporate data warehouse project

No comments:

Post a Comment