Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 49274 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
Explain the data types present in bo n wht happens if we implement view in the designer n report?
How to export mappings to the production environment?
Explain what are the modules in power mart?
What is the definition of cube in datawarehousing?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Where the data cube technology is used?
What are different deliverables according to phases?
Explain what are snapshots? What are materialized views & where do we use them? What is a materialized view log?
What are the various methods of getting incremental records or delta records from the source systems?
What are partition points?
What is a real-time data warehouse? How is it different from near to real-time data warehouse?
Why null values are mapped as 0 in fact tables?
Explain when do we analyze the tables? How do we do it?
What should I have in mind when building olap solution from scratch?
What is data analytics in simple terms?
