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
How can we do data cleaning?
Tell me what is full load & incremental or refresh load?
What is Operational Data Store?
What are the approaches used by optimizer during execution plan?
What is the difference between star and snowflake schemas?
Explain degenerate dimension table?
What is VLDB?
What is the advantages data mining over traditional approaches?
What are the various tools? Explain name a few?
Explain what is the difference between view filter and report filter?
Explain in detail abt measure objects? And what is the use of it? How to create it?
What are the tools available for etl?
Explain a relation schema and a relation?
What is the difference between dependent data warehouse and independent data warehouse?
what are relationships?