Double Counting in Aggregation
Join an order to its shipments and the order amount appears once per shipment. The join is correct; the sum is not. This is where inflated totals come from.
-
-
Join Cardinality
Predict matching row counts, distinguish unmatched rows from NULL attributes, and prevent repeated order amounts from inflating totals.