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
What is index awareness in universe?
What is data warehouse architecture?
How many clustered indexes can you create for a table in dwh? In case of truncate and delete command what happens to table, which has unique id.
What are the stages that are required in data warehousing?
What is surrogate key? Explain with examples.
What needs to be done when the database is shutdown?
What are the different types of datawarehosuing?
What is a functional dependency f said to be minimal?
What is difference between e-r modeling and dimensional modeling?
What are the design methods of data warehousing?
What is Active Datawarehousing?
Difference between cold fusion 5 and cold fusion mx 6?
Suppose date is 05sep2005; I want the output like 05sep2005:00:00:00 ; how it will come?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What are aggregate tables and aggregate fact tables?