Data Engineering, Interview, Data Modeling.
dimensions are further normalized, leading to branching or “snowflaking” out into other tables, like the Product and Category relationship shown above. Star Schema: Fact Table - Sales: | Sale_ID | Date_Key | Product_Key | Customer_Key | Quantity_Sold | Total_Sale| | - - - - | - - - - -| - - - - - -