Star schema VS Snowflake schema

siva7143 · Post by **siva7143** » Fri Apr 03, 2009 4:15 am

Can snowflake schema be later converted into Star schema?

a) Yes
b) No

Thanks in advance......

ray.wurlod · Post by **ray.wurlod** » Fri Apr 03, 2009 5:21 am

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.

chulett · Post by **chulett** » Fri Apr 03, 2009 7:09 am

Ah, there it is.