What is the difference between a data warehouse and a data mart?
Answer Posted / thakkalpelly anil
a data warehouse is a relational database which is
specially designed for analysis purpose rather then for
transactional purpose.
a datmart is subject oriented database which gives the data
about each and every individual department in an
organisation.
Is This Answer Correct ? | 47 Yes | 9 No |
Post New Answer View All Answers
What are snapshots? What are materialized views & where do we use them?
What is a fact, dimension, measure?
What is the difference between olap and oltp?
What are the data marts?
Explain what is the advantages data mining over traditional approaches?
How to drill through from a powerplay cube to reportnet?
How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?
Explain what is the difference between powerplay transformer and power play reports?
What are the different types of scd's used in data warehousing?
How to create context?
Explain the differences between normalizer and normalizer transformation?
Explain what are data marts?
How can we run the graph? What is the procedure for that?
What is crass reference table?
What is defined as partial backup?