A product dimension contains a free-text audit note unused by reports, relationships, or security. Why remove it before importing?

Published
  1. It can increase storage through unnecessary high cardinality
  2. Removing it changes fact-table grain
  3. It forces DirectQuery for the remaining columns
  4. Hidden audit notes are never loaded anyway

Comments — 0