Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 49241 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
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
Where do we use semi and non additive facts?
Which parameter specified in the default storage clause of create tablespace cannot be altered after creating the table space?
What is the main difference between star and snowflake star schema? Which one is better and why?
What are aggregate transformation?
What are the various tools? Explain name a few?
What is the limit to the number of sources and targets you can have in a mapping?
What is critical column?
What is data type of the surrogate key?
Explain what is metadata reporter?
What is surrogate key? Explain with examples.
What are the key features of chameleon that separates it from other algorithms?
What is metadata in context of a datawarehouse and how it is important?
What is a source qualifier?
What are the difference between snow flake and star schema?
what is an use case?
