What is star schema and snowflake and their uses cases

Question

Accepted Answer

Star schema and snowflake are data modeling techniques used in data warehousing.

Star schema is a denormalized schema where a central fact table is connected to multiple dimension tables in a star-like structure.
Snowflake schema is a normalized form of star schema where dimension tables are further normalized into sub-dimension tables.
Star schema is more suitable for simpler queries and faster performance, while snowflake schema allows for more flexibility and scalability.
Star schema is commonly used in data marts and data warehouses for reporting and analytics.
Snowflake schema is preferred when there is a need for more complex data relationships and data integrity.

Top Velocis Systems ETL Developer Lead interview questions & answers