Q#20 What are DataMarts? Give its advantages over Data Warehouse - TopicsExpress



          

Q#20 What are DataMarts? Give its advantages over Data Warehouse and disadvantages. A. A Data Mart is a subset of a data warehouse and it deals with a specific task. Advantages- Data Mart deals with single subject area and lesse number of dimensions; It has limited feeds; It shows quick impact on bottom line problems; Has more focus on user needs; Has limited scope; Demonstrates of Return of Investment; And allows prototyping. Disadvantages- The integrated form of business data is not provided; Redundancy of data is high; Existence of too many data marts are difficult to handle; Issues of Scalability occur.
Posted on: Fri, 14 Jun 2013 23:34:09 +0000

Trending Topics



Recently Viewed Topics




© 2015