Direct Datas

Brief to file

Prepared properly, or not sent at all.

A requirement arrives in words and leaves as criteria. Checks run against the output, not against the intention. What cannot be evidenced is left out and listed.

Change tracking
What moved since the last delivery, so a refresh does not read as a new universe.
Record identifiers
Giving every row a stable key so a later refresh can be matched against this one.
Geography resolution
Working out which location a record belongs to when it carries several addresses.

A brief in your own words beats a template.