A silver layer should exclude records with missing mandatory order IDs. Which transformation is appropriate?

Published
  1. Replace every missing ID with the same fixed constant
  2. Silently drop the key column from all outputs
  3. Assume Delta automatically infers every business requirement
  4. Validate the key and filter or quarantine invalid records

Comments — 0