Snowflake Schema

n      Snow flake wont have much of redundant data as most of the dimensions will have a look table. This way the number of joins between the tables will become more.

n      Represent dimensional hierarchy directly by normalizing tables.

n      Easy to maintain and saves storage

n      Both have advantages and dis advantages, so analyze the end users requirements and space constraints to pick the best.