A numeric field is missing in some records. Why should the engineer not automatically replace every missing value with zero?

Published
  1. Replacing values never affects aggregates
  2. Missing and zero can have different business meanings
  3. NULL values can never appear in analytical data
  4. Zero always means unknown in every dataset

Comments — 0