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 the differences between star and snowflake schema?
what is parallel query?
What is factless fact tables?
In microstrategy, how can we direct the sql generated to use a specifc table?
Compare cold fusion with other programming languages?
What is type 2 version dimension?
Why should we use data ware housing and how can you extract data for analysis with example?
What is cost benefit analysis (cba)?
What are the advantages and disadvantages of reporting directly against the database?
What is meant by metadata in context of a data warehouse?
What are the different types of scd's used in data warehousing?
What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is difference between query studio and report studio?
What are the stages that are required in data warehousing?
What are the stages of datawarehousing?