What is the difference between a data warehouse and a data mart?
- 15 Answers
- 43468 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
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 are the advantages of cold fusion?
What is the 4 + 1 view model as it relates to system modeling?
What are the mapping paramaters and maping variables?
What is load manager?
What are session timeout and application timeout? Where we have to do this process?
What are session timeout and application timeout?
Explain what is full load & incremental or refresh load?
What is the definition of cube in datawarehousing?
Explain what are the tasks that loadmanger process will do?
How to know the time taken for particular report execution?
Explain what are the advantages data mining over traditional approaches?
Code the tables statement for a single-level (most common) frequency?
What is a relationship?
Explain the difference between view and materialized view?
Suppose your client wants to ensure only specific users can create reports in query studio with other users creating reports using report studio. How can this be accomplished?
