PL-002 · Reference Data
Customer Master Conformance
Slowly changing dimension (Type 2) build for a synthetic customer master, including tokenisation of sensitive attributes before load.
degraded
HourlySLA 45 minSimulated CRM export (CSV) → DW.DIM_CUSTOMERStage flow
Average stage durations from the simulated run history.
- 1
Staged file landing extract
External table over the staged synthetic extract with checksum verification.
~22s average
- 2
Tokenise restricted fields transform
Deterministic tokens replace synthetic tax IDs and contact details before any persistence.
~39s average
- 3
SCD2 merge load
MERGE with effective-dating and current-flag maintenance.
~88s average
- 4
Conformance report validate
Duplicate-rate and completeness scorecard published to the quality log.
~12s average
Recent runs
Synthetic history — not sourced from a live scheduler.
| Run | Started (UTC) | Duration | Rows in | Rows out | Reject % | SLA | Status |
|---|---|---|---|---|---|---|---|
| R-4410 | 2026-08-13 16:00:00 | 244s | 61,200 | 60,011 | 1.94% | Met | degraded |
| R-4409 | 2026-08-13 15:00:00 | 168s | 59,980 | 59,912 | 0.11% | Met | healthy |
| R-4408 | 2026-08-13 14:00:00 | 175s | 59,444 | 59,390 | 0.09% | Met | healthy |