Data Validation – Compare shared data with Prod data, validate gaps and report

XMLWordPrintable

    • FLW Sprint 55, FLW Sprint 56
    • Admin
    • Prod

      Background / Context

      Data has been shared for this activity and needs to be compared against the Prod data.
      [TBD/CLARIFICATION REQUIRED: what "the data shared" is (file, source, owner) and which activity it belongs to.]

      Problem Statement

      The shared data has not been checked against Prod data, so any gaps (missing records) are unknown.

      Expected Behaviour / Requirement

      1. Compare the shared data with the Prod data.
      2. Validate the gap, i.e. identify anything that is missing.
      3. Report the findings.

      User Story

      As an operations/admin user, I want the shared data compared against Prod data and the gaps reported, so that missing records are identified before further action.

      Acceptance Criteria

      • Given the shared data and the Prod data, when the comparison is run, then every record that is missing or mismatched is identified.
      • Given gaps are found, when the report is prepared, then it lists the affected records.
      • Given no gaps are found, then the report states that the data matches.

      Dependencies

      • The shared data file/source.
      • Access to Prod data for the comparison.

      Impact / Affected Areas

      • Prod data (read/compare).
        [TBD/CLARIFICATION REQUIRED: confirm the comparison is read-only and makes no change to Prod.]

      QA / Testing Considerations

      • Verify the report against a sample of records from both sources.
      • Confirm counts reconcile (shared data, Prod data, matched, missing).

              Assignee:
              Saurav Mishra
              Reporter:
              Shivani Garg
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

                Created:
                Updated: