Sales contains repeated ProductID values; Product contains one row per ProductID. Which relationship usually fits a star schema?

Published
  1. Product one-to-many Sales with single-direction filtering
  2. No relationship and a slicer on Sales Amount
  3. Sales one-to-one Product
  4. Bidirectional many-to-many by default

Comments — 0