What is the difference between a data warehouse and a data mart?
Answer Posted / mohit
In Data warehouse -- data received from staging area
In data mart -- star join (facts and dimension )
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
How do you setup Lo-cockpit?
What are loops in Datawarehousing?
What are the different types of schemas used in data warehousing?
What are the different problems that ?Data mining? can solve?
How to limit the max no of rows retrieved in the report?
What is the data type of the surrogate key?
What are aggregate tables and aggregate fact tables?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
What is incremintal loading?
How to provide security in frame work manager for a query subject?
Explain the different types of data warehousing?
Explain what is data validation strategies for data mart validation after loading process?
What are the stages that are required in data warehousing?
Explain what are data marts?
Do you view contain data?