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
Explain a relation schema and a relation?
Store (and count) non-fact records?
What should I have in mind when building olap solution from scratch?
What are the reasons to use a chameleon method in data warehousing?
How to create prompts in report net?
What is a real-time data warehouse?
How did you plan your Data ware house project?
How can you implement many relations in star schema model?
Define Data Warehousing?
Where the data cube technology is used?
How do you define data block size?
why we use dmr model in cognos report studio ? give me difference between dmr model and relational model.
What is surrogate key? Where we use it? Explain with examples.
What are the types of SCD?
What is conformed fact?