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
Explain what principles of dimensional modeling this fact table violates
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am