I know basic difference between star and snowflake schema, but i have bit confusion between both, when and which condition we should follow which schema.
I have observe that people generally followed answer as star schema is best but they didn't able to explain properly.
Expecting answer with scenario. Thanks in advance.
