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
Explain in detail abt measure objects? And what is the use of it? How to create it?
What is loop in data warehousing?
What is surrogate key? Where we use it? Explain with examples.
Do you always need to copy the data before reporting on it?(Example, real-time & on-demand reporting is a requirement)?
How can you set the session management?
What is dimensional modelling?
what are the different views that are considered when building an object-oriented software system?
Explain what are non-additive facts?
What are situations where snowflake schema is better than star schema when the opposite is true?
How to get the first 100 rows from the flat file into the target?
Explain what is a three tier data warehouse?
What is meant by metadata in context of a data warehouse?
What is the difference between metadata and data dictionary?
Explain about core dimension, balanced dimension, and dirty dimension?
What is data mart in data warehouse?