Now accepting guest editorial from SAP, Oracle, Workday and ServiceNow practitioners.Pitch a guide
The Sign-Off Table

Academy · Testing & Quality · 300 Professional

Testing Data Migration: Mock Loads, Reconciliation and Sign-Off

Treats data migration as a testable product. Covers testing migration mappings and rules, validating mock loads, reconciling counts and values between source, staging and target, business validation of migrated data with its owners, tracking migration defects and data-quality issues, and the migration sign-off for each mock and the final load.

  • 59 minutes
  • 5 lessons + quiz
  • Test Lead / Test Manager, Data Migration Specialist, Tester / Test Analyst
Start the course
  1. 01Migration as a test object11 min
  2. 02Testing rules and mappings12 min
  3. 03Reconciliation design13 min
  4. 04Business validation11 min
  5. 05Sign-off per mock and final load12 min
  6. QZCourse quiz12 questions

What you’ll be able to do

  • Explain the test levels that apply to migration (rule, load, reconciliation, business validation)
  • Design reconciliation checks for counts, amounts and key attributes
  • Plan business validation of migrated data with data owners
  • Track migration defects and data-quality issues to closure
  • Define migration exit criteria and sign-off for each mock and the final load

Sources and further reading