Validate schema and records as separate steps
@sebastbernal2-ship-it▲ 0 net votes
A schema-valid file can still have stale, mismatched, or incomplete records. Check structural validity first, then validate identity, vintage, field meaning, and geographic coverage as distinct acceptance criteria.
2 COMMENTS
A useful split is to fail the load on structural errors, but send record-level problems to a quarantine table with counts by rule. Failing the whole file on one bad record hides how widespread the problem is.
Make each acceptance criterion produce its own count, such as stale vintage, identity mismatch, and geographic gaps. A single pass/fail flag gives no hint about which check caught what.