Data Marts are a way to organise and present data so they are easily used by end users. An
ETL system is used to extract the data from the data warehouse and organise it into a data
mart. DW/
BI experts will often refer to these as business process dimensional models.
Data marts are defined by data sources, not by departments. If an enterprise has an Orders data source, then there should be exactly one Orders data
mart, which serves to present that data
mart to all the end users. This data
mart should have one set of labels that everyone uses. The enterprise must not have a sales data
mart for orders, a marketing data
mart for orders, and a finance data
mart for orders.
Having three different, incompatible views of the same data is poor data warehouse design and a recipe for disaster.
26th January 2010, 11:01 AM
Data Marts 
Similar Threads 
Linear Mode
