Please go with Star schema becoz the server performance and extraction is good in star schema compared to snowflake schema.
Muthu Krishnan. M
Thanks Muthu, we also preferred the same!!But still we would like to know the limitations when we go with snow flake ,or best practices that can be followed when we go with snowflake
There are really no limitations on the complexity of the schema (star, snowflake, OLTP/3NF) that you choose to use. The real issue is how much longer a "complex" query (which includes many more joins) will execute on your data system vs. a more simple one...