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 use of tabular model, tabular sql, tabular reference in real time application?
Explain the main differences between star and snowflake schema?
What is a real-time data warehouse?
Is union transormation is active transformation?
what are the other factors of the database on which the loading performance depend?
Explain difference between view and materialized view?
What is hybrid slowly changing dimension?
What are data modeling and data mining? Where it will be used?
Database in use is oracle?
What is the function of etl when used in data warehousing?
What is a functional dependency f said to be minimal?
What are the types of dimensional modeling?
What is the difference between constraind base load ordering and target load plan?
Why is business intelligence (bi) important in data warehousing?
Explain the data type of the surrogate key?