etl - When do we consider snowflaking a star schema?

Question

In the below dimensional model, all the dimension table follows the star schema except the prod table, which is snowflaked and has prod_sub table as a child table. What is the strategical point to consider snowflaking a star schema?

Sales Table - Fact Table
Prod_id  (fk)
Promo_id (fk)
store_id (fk)

Promo Table - Dimension Table
promo_id (pk)

Store Table - Dimension Table
store_id (pk)

Product Table - Dimension Table
Prod_id (pk)
prod_class_id (FK)
Prod_name
Prod_brand

Prod_sub Table- Dimension Table (snow flaked)
prod_class_id,
prod_class
prod_sub_class
prod_family

question from:https://stackoverflow.com/questions/65875735/when-do-we-consider-snowflaking-a-star-schema

Answer 1

According to Kimball : Star Schema is the best way of designing a data model for reporting, You will get the best performance and also flexibility using such a model. So no need to snowflake it.

Then your Product Table Dimension Table becomes :

Product Table - Dimension Table
Prod_id (pk)
Prod_name
Prod_brand
prod_class
prod_sub_class
prod_family