Can snowflake schema be later converted into Star schema?
a) Yes
b) No
Thanks in advance......
Star schema VS Snowflake schema
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Maybe, by denormalizing the dimension. But, if so, why have the snowflakes in the first place?
When's the interview?
Actually, a better answer to this question is always "yes", if one is happy to ignore questions of efficiency. For example the holiday table associated with a time dimension is typically a snowflake, or even many if you have separate holiday tables for separate countries.
When's the interview?
Actually, a better answer to this question is always "yes", if one is happy to ignore questions of efficiency. For example the holiday table associated with a time dimension is typically a snowflake, or even many if you have separate holiday tables for separate countries.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.