Control detail

Warehouse ETL reconciliation

ctl-038 · DETECTIVE · DAILY

ctl-038

Warehouse loads reconcile record counts and control totals to source.

Type
DETECTIVE
Automation
AUTOMATED
Frequency
DAILY
Owner
Data Platform Engineering

Control Design Assessment (CDA)

Procedures evaluating whether the control is designed adequately.

No design-assessment procedures defined yet.

Control Operating Effectiveness (COE)

Procedures evaluating whether the control operated over the testing period.

No operating-effectiveness procedures defined yet.

Linked risks

  • Warehouse data lineage gapsmitigation 2
  • Cross-system reconciliation breaksmitigation 2

Framework mappings & latest test

DSP-23
Latest test:PASS2026-05-20