Explain what principles of dimensional modeling this fact table violates
Posted: Fri Jul 01, 2022 5:38 am
Explain what principles of dimensional modeling this fact tableviolates
Date Dimension Date_PK Date Month quarter year Store Dimension Store_PK Name Street city Area zone market outlet Sales Fact Transaction ID Date Key (FK) Product Key(FK) Customer Key(FK) Store Key(FK) Sales Dollars Product Dimension Product_PK Name code City zipcode state category description expiry_date Customer Dimension Customer_PK Customer Name Customer Address
Date Dimension Date_PK Date Month quarter year Store Dimension Store_PK Name Street city Area zone market outlet Sales Fact Transaction ID Date Key (FK) Product Key(FK) Customer Key(FK) Store Key(FK) Sales Dollars Product Dimension Product_PK Name code City zipcode state category description expiry_date Customer Dimension Customer_PK Customer Name Customer Address