What is the difference between a data warehouse and a data mart?
- 15 Answers
- 43644 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
How can we schedule the graph in unix?
How would you write a left join statement to return a result set of movie.title�s and director.name�s?
What is the difference between olap and oltp?
How many different schemas or dw models can be used in siebel analytics. I know only star and snow flake and any other model that can be used?
Suppose I want to get sales data for the last (suppose 10) dates dynamically using value prompt how can I do it and drag it onto report editor?
What are snapshots? What are materialized views & where do we use them?
What is data validation strategies for data mart v?
Whether dimension table can have numeric value?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in
Explain what is the difference between datawarehouse and bi?
How to load the time dimension?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
What are the tools available for etl?
Explain what is the difference between power center & power mart?
What are different deliverables according to phases?
