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


Please Help Members By Posting Answers For Below Questions

What are snapshots? What are materialized views & where do we use them?

515


What is a fact, dimension, measure?

543


What is the difference between olap and oltp?

550


What are the data marts?

517


Explain what is the advantages data mining over traditional approaches?

569






How to drill through from a powerplay cube to reportnet?

494


How can we run the graph? What is the procedure for that? How can we schedule the graph in unix?

550


Explain what is the difference between powerplay transformer and power play reports?

630


What are the different types of scd's used in data warehousing?

558


How to create context?

591


Explain the differences between normalizer and normalizer transformation?

511


Explain what are data marts?

577


How can we run the graph? What is the procedure for that?

498


What is crass reference table?

581


What is defined as partial backup?

618