Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 49272 Views
- Apex, ASD Lab, Bank Of America, I also Faced
- E-Mail Answers
Answer Posted / sree
data mart is a scaled version of datawarehouse which
addresses to only a particular subject
datawarehouse is a database which allows to view the data
in different dimensions or perspectives
| Is This Answer Correct ? | 9 Yes | 4 No |
Post New Answer View All Answers
What is pre-emptive and non-pre-emptive?
What are non-additive facts in detail?
Explain what is a staging area? Do we need it? What is the purpose of a staging area?
What is the difference between olap and oltp?
Difference between e-r modeling and dimentional modeling?
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.
How to load the time dimension?
Explain the difference between filter and conditin?
What is the data type of the surrogate key?
Can any one explain about core dimension, balanced dimension, and dirty dimension?
Explain what are the possible data marts in retail sales?
Explain why are oltp database designs not generally a good idea for a data warehouse?
Explain dimension table ?
What is surrogate key? Where we use it explain with example?
What is Cognos script editor?
