Why should we use star schema in datawarehouse design?
Answer Posted / arun
Star schema has less joins within its related dimensions so query retreival is faster than SNow-flake.
Space consumed is more than snow-flake
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What is mapplet in informatica?
What is native users?
4 yrs etl devloper roles and responsibilities?any body give solutions
Explain about cumulative Sum or moving sum?
update strategy transformation in informatica
What is Story point Estimation ? Can any one give just an introduction about this ? Advance Thanks
What is a dimensional model?
Explain the different lookup methods used in informatica?
Briefly explain the aggregator transformation?
Explain the scenario which compels informatica server to reject files?
What is substr in informatica?
pmscmd startworkflow -sv
What could be the possible resons of locks by user?
Enlist few areas or real-time situations where informatica is required.
What are the types of schemas we have in data warehouse and what are the difference between them?