Question

What is Snowflake Schema?

Answer 1

Snowflake Schema is a large denormalized dimension table is split into multiple normalized dimensions.

Advantage:

1. Select Query performance increases.

Disadvantage:

1. Maintenance cost increases due to more no. of tables.