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 is the metadata extension?
What are the various methods of getting incremental records or delta records from the source systems?
Explain difference between snow flake and star schema. What are situations where snow flake schema is better than star schema to use and when the opposite is true?
What is analytical or analytic mean?
What is the difference between a primary and secondary actor in use case modeling?
Explain what are non-additive facts in detail?
What is the difference between power center & power mart?
Explain what are data marts?
Explain what are the modules in power mart?
What is static and local variable?
Explain how to get the first 100 rows from the flat file into the target?
Explain the hierarchies level data warehousing.
how much memory space occupied real time project (roughly)?
Explain what is type 2 version dimension?
How to reduce warnings?