Answer Posted / Raja Sirohi

The main difference between a star schema and a snowflake schema lies in the normalization of data. Both are optimized for different types of queries:nn- Star Schema: Uses denormalization, where fact tables are joined to dimension tables through foreign keys. This design provides fast query performance for aggregation queries but can lead to redundancy.n- Snowflake Schema: Normalizes the data further by separating the dimensional tables into multiple hierarchical layers. This design reduces redundancy but may negatively impact query performance for aggregation queries.

Name top 10 bi tools?

5