Difference between Snow flake and Star Schema. What are situations where Snow flake Schema is better than Star Schema to use and when the opposite is true?
Star schema contains the dimesion tables mapped around one or more fact tables.
It is a denormalised model.No need to use complicated joins.Queries results fastly.Snowflake schemaIt is the normalised form of Star schema.contains indepth joins ,bcas the tbales r splitted in to many pieces.We can easily do modification directly in the tables.We hav to use comlicated joins ,since we hav more tables .There will be some delay in processing the Query .
Explore posts in the same categories: Data WareHousing Interview Questions