What is the difference between a data warehouse and a data mart?
Answer Posted / anonymous
data mart-A Data Mart is a specific, subject oriented,
repository of data designed to answer specific questions
for a specific set of users. So an organization could have
multiple data marts serving the needs of marketing, sales,
operations, collections, etc. A data mart usually is
organized as one dimensional model as a star-schema (OLAP
cube) made of a fact table and multiple dimension tables.
data warehouse-In contrast, a Data Warehouse (DW) is a
single organizational repository of enterprise wide data
across many or all subject areas. The Data Warehouse is the
authoritative repository of all the fact and dimension data
(that is also available in the data marts) at an atomic
level.
Is This Answer Correct ? | 14 Yes | 4 No |
Post New Answer View All Answers
How did you plan your Data ware house project?
How to handle multi value dimensions?
What is a staging area? Do we need it? What is the purpose of a staging area?
How to test report in reportnet?
What are session timeout and application timeout? Where we have to do this process?
Explain difference between data ware house & data mart?
what are different storage options supported by oracle ?
What are non-additive facts in detail?
What is the goal of optimizer?
Explain what are conformed dimensions?
Explain difference between view and materialized view?
What are the various file formats involved in reportnet?
Explain what is power center repository?
How to allow a dynamic selection of a column for a measure in a chart,without using variable?
What is pre-emptive and non-pre-emptive?