What is the difference between a data warehouse and a data mart?
Answer Posted / thakkalpelly anil
a data warehouse is a relational database which is
specially designed for analysis purpose rather then for
transactional purpose.
a datmart is subject oriented database which gives the data
about each and every individual department in an
organisation.
| Is This Answer Correct ? | 47 Yes | 9 No |
Post New Answer View All Answers
Why should you put your data warehouse on a different system than your oltp system?
What is drill-through?
Explain why denormalization is promoted in universe designing?
Explain have you ever been in a real dilemma at work? What did you do to get out of it?
What are the advantages of raid 1, 1/0, and
How to performance tune reports?
Explain what are the vaious etl tools in the market?
Explain er diagram?
What are the different types of segments?
How can we run the graph? What is the procedure for that?
Explain what is real time data-warehousing?
Store (and count) non-fact records?
What are diagrams?
what are confirmed dimension? We alwys give date as a conformed dimension but if it has different format for different contries say YYMMDD for italy and MM-DD-YYYY for france.Then are they not confirmed.
What is the difference between power center and power mart?