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 difference between mapping parameter & mapping variable in data warehousing?
Where we use surrogate key explain with example?
What is the 4 + 1 view model as it relates to system modeling?
What is mean by aggregate aware?
What are target types on the server?
How to performance tune reports?
What is junk dimension? What is the difference between junk dimension and degenerated dimension?
What is static and local variable?
Is framework manager an un-needed overhead? As we know report studio allows us to create the data model from a query and thereby skipping framework manager. Given that this feature is available, in what scenarios would one want to skip framework manager?
What are different deliverables according to phases?
Explain how does tuple-oriented relational calculus differ from domain-oriented relational calculus?
Explain me what are data marts?
Explain what is the data type of the surrogate key?
How to add a number to a macro variable?
What is the difference between agglomerative and divisive hierarchical clustering?