DSXchange

Can snowflake schema be later converted into Star schema?

a) Yes
b) No

Thanks in advance......

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.

Ah, there it is.