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
I have two universes created by two difference database can we join them in designer & report level? How
What is meant by metadata in context of a data warehouse?
Is union transormation is active transformation?
How to add a number to a macro variable?
Define Data Warehousing?
What is VLDB?
Fact table is in normalized or de-normalized form?
What are the stages that are required in data warehousing?
Where the cache files stored?
What is perform recovery?
What is the difference between constraind base load ordering and target load plan?
Explain why should you put your data warehouse on a different system than your oltp system?
Explain what are the different types of data warehousing?
Whether dimension table can have numeric value?
Explain what is the difference between a primary and secondary actor in use case modeling?