What is the difference between a data warehouse and a data mart?
Answer Posted / naveen goyal
In Data warehouse, staging area is used for mapping and
integration of data collected from different sources, but in
data marts staging area is eliminated because data directly
transfers from various source systems to data marts.
Is This Answer Correct ? | 12 Yes | 6 No |
Post New Answer View All Answers
What are the types of partitioning?
Explain what are the various transformation available?
Hyperion is the one of the tool in data ware house. Its an olap tool. Why you cant display that tool?
Which are the olap tools available that are supported by oracle?
What is meant by metadata in context of a data warehouse?
Explain which columns go to the fact table and which columns go the dimension table?
What is the use of tabular model, tabular sql, tabular reference in real time application?
What is many-to-many dimensional model in datawarehousing ?
Explain what is partitioning? What are the types of partitioning?
What is degenerate dimension table?
What are the various file formats involved in reportnet?
What is difference between query studio and report studio?
What is surrogate key? Where we use it explain with example?
Explain difference between data ware house & data mart?
what is user variable in affinium campaign? and some real time examples.