what is the difference b/w star and snowflack schema in dataware house?
Star schema is one fact table in the middle is sorrounded by many dimension tables and no extenssion for the dimensin table it means denormalized. Snowflake schema is where the dimension table is extended to normalized form