What is the difference between a data warehouse and a data mart?

Answer Posted / sree

data mart is a scaled version of datawarehouse which
addresses to only a particular subject
datawarehouse is a database which allows to view the data
in different dimensions or perspectives

Is This Answer Correct ?    9 Yes 4 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is the difference between snowflake and star schema? What are situations where snowflake schema is better than star schema when the opposite is true?

575


What is the limit to the number of sources and targets you can have in a mapping?

557


Explain differences between star and snowflake schemas?

536


What are the key columns in Fact and dimension tables?

546


What is real-time datawarehousing?

607






What is the difference between connected and unconnected stored procedures?

548


What are the advantages and disadvantages of using stored procedures versus calling sql inline in cold fusion?

569


does anyone "QlikView" BI tool. if you have any docs send me pls. yaparas84@gmail.com

5472


Where the applications and where

518


Describe the differences between a data warehouse and data mart.

506


Explain vldb?

625


How can we schedule the graph in unix?

560


How to create diff. Types of templates?

562


Explain in detail abt measure objects? And what is the use of it? How to create it?

553


What are the differences between star and snowflake schema?

494