30 April 2012 1:40
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;
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 ?
A database with all of these Fact and Dimension tables is a Data Mart ?
30 April 2012 3:30
The following link may be helpful.
ESHANI. Please click "Mark As Answer" if a post solves your problem or "Vote As Helpful" if a post has been useful to you
- Disarankan sebagai Jawaban oleh Jerry NeeModerator 30 April 2012 10:19
30 April 2012 3:45
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
Best Wishes, The Redman; If something helps, please help show it by voting, if it solves, bonus!
04 Mei 2012 14:25
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.
10 Mei 2012 20:18
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