Friday, September 24, 2010

what is data mart?

A data mart is a group of related fact tables and their corresponding dimension
tables containing the measurements of business events, categorized by their dimensions. Data marts exist in dimensional data stores


A data mart (the fact table and its dimensions) stores a collection of business events in a certain business area. To design the fact tables and dimensions,
we need to have business knowledge in that business area

Ex: Product sales
subscriber profitability
supplier performance

1 comment: