A nightly source is small and has no reliable change indicator. Which initial loading design is simplest if replacement is acceptable?

Published
  1. A delete-only job
  2. An incremental query on an invented UpdatedAt field
  3. A random sample appended each night
  4. A validated full replacement load

Comments — 0