What is a Data Mart ?

Question

Is a Data Mart a Single Fact table ? Or is it a whole Database Model consisting of Facts and Dimensions ?

For Example: In our Datawarehouse we have the following;

Dim Address

Dim Product

Dim Industry

Fact Sales

Fact Marketing

All of the Dimensions are the conformed dimension being shared by both of the dimensions. Also all of these table fall under a same cube because users want to query on both sales and marketing at the same time.

Is Fact Sales a Single Data Mart ? IS Fact Marketing a Single Data Mart ?

OR,

A database with all of these Fact and Dimension tables is a Data Mart ?

Answer 1

The following link may be helpful.

http://docs.oracle.com/html/E10312_01/dm_concepts.htm

---

ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you

Answer 2

Data Marts are essentially a stipped down data warehouse, their purpose is to focus on a particular area (In your case Sales or Marketing).

So you may have your data warehouse, and create two data marts over the top of it.  This could be due to Sales wanting to see a different presentation layer to Marketing.  If your Marketing and Sales warehouse is constructed from a much larger warehouse, than it is already likely a data mart.

Some will also refer to it as a data mart, if your company has other similiar small data warehouses, and are looking to combine them into a larger data warehouse.

This might help you out in your understanding

http://msdn.microsoft.com/en-us/library/dd459147(v=sql.100).aspx

---

Best Wishes, The Redman; If something helps, please help show it by voting, if it solves, bonus!

Answer 3

Data Mart is a subset of the data resource, usually oriented to a specific purpose or major data subject, that may be distributed to support business needs. The concept of a data mart can apply to any data whether they are operational data, evaluational data, spatial data, or metadata.

A data mart is a repository of a business organization's data implemented to answer very specific questions for a specific group of data consumers such as organizational divisions of marketing, sales, operations, collections and others. A data mart is typically established as one dimensional model or star schema which is composed of a fact table and multi-dimensional table.

Answer 4

hello Nadir

Please Read this..

A data mart is the access layer of the data warehouse environment that is used to get data out to the users. The data mart is a subset of the data warehouse which is usually oriented to a specific business line or team. facts and dimensions, then they will be related.

More information :http://en.wikipedia.org/wiki/Data_mart

Best Regards

---

Leonardo Martínez