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 needs to be done while starting the database?
What is a core dimension?
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
I need to set predefined condition. How I do this?
Why fact table is in a normal form?
What is data validation strategies for data mart v?
What is Discover and Execute in XMLA?
Explain what is the difference between view filter and report filter?
What is a linked cube?
Explain the versions of reportnet?
Can you pass sql queries in filter transformation?
What are fact, dimension, and measure?
Explain the difference between view and materialized view?
What are session timeout and application timeout?
What is data stream and data adaopter. Is it same are different? Explain?