What is the difference between a data warehouse and a data mart?
Answer Posted / prasanta
Data Warehouse is used on an enterprise level, while Data
Marts is used on a business division/department level. A
data mart only contains the required subject specific data
for local analysis.
| Is This Answer Correct ? | 30 Yes | 1 No |
Post New Answer View All Answers
What is the very basic difference between data warehouse and operational databases?
How to performance tune reports?
Explain techniques of error handling - ignore , rejecting bad records to a flat file , loading the records and reviewing them (default values)?
Store (and count) non-fact records?
What are aggregate tables and aggregate fact tables?
Difference between cold fusion mx 6 and cold fusion mx 7?
Where the cache files stored?
What is a general purpose scheduling tool?
Explain vldb?
Could any one explain me how to create cascading prompts?
How do you create surrogate key using ab initio?
What are the reasons to use a chameleon method in data warehousing?
What is difference between model & package?
What does level of granularity of a fact table signify?
What are the possible data marts in retail sales?