A fact table mixes one row per order with one row per order line. Why is this a design problem?

Published
  1. Delta requires every table to contain only strings
  2. The table cannot be governed by Unity Catalog
  3. The inconsistent grain can distort joins and aggregations
  4. Every table must have exactly one partition

Comments — 0