What is the difference between a data warehouse and a data mart?
Answer Posted / guest
Dataware house: It is a collection of data marts.
Represents historical data.
Data mart: It is a sub set of data ware housing.
It can provide the data to analyze query reporting
& analysis.
| Is This Answer Correct ? | 69 Yes | 18 No |
Post New Answer View All Answers
What is difference between model & package?
Code the tables statement to produce a multi-level frequency?
What are the difference between snow flake and star schema?
What is the data type of the surrogate key?
Explain is fact table?
How to test report in reportnet?
Explain what type of indexing mechanism do we need to use for a typical datawarehouse?
Explain what are components of reportnet?
what are the different views that are considered when building an object-oriented software system?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain a mapping, session, worklet, workflow, mapplet?
Explain what is a three tier data warehouse?
Explain me what are data marts?
Explain if a flat file cotains 1000 records how can I get first and last records only?
What are snapshots? What are materialized views & where do we use them?