Interested to Buy Any Domain ? << Click Here >> for more details...
What is the difference between a data warehouse and a data mart?
- 15 Answers
- 48200 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 is MODEL is Data mining world?
Explain datawarehousing?
What are situations where snowflake schema is better than star schema when the opposite is true?
Explain differences between star and snowflake schemas?
In a star schema, are foreign key constraints between facts and dimensions neccessary?
Suppose we have some 10,000 odd records in source system and when load them into target.how do we ensure that all 10,000 records that are loaded to target doesnt contain any garbage values?
What is surrogate key? Where we use it explain with example?
How can you implement many relations in star schema model?
What is a source qualifier?
Explain what is power center repository?
What are the advantages of query studio compared to report studio?
Can you pass sql queries in filter transformation?
Explain dimensional modelling?
What is static and local variable?
Why denormalization is promoted in universe designing?
