PL-004 · Retention
Archive & Purge Cycle
Retention enforcement job that moves aged partitions to a compressed archive tablespace and purges expired synthetic records.
paused
Nightly 02:00SLA 90 minDW.FACT_BILLING → Archive tablespaceStage flow
Average stage durations from the simulated run history.
- 1
Retention scan extract
Identifies partitions past the retention boundary.
~41s average
- 2
Compress & exchange transform
Partition exchange into a compressed archive segment.
~320s average
- 3
Purge confirmation validate
Row-count and checksum proof before purge is committed.
~64s average
Recent runs
Synthetic history — not sourced from a live scheduler.
| Run | Started (UTC) | Duration | Rows in | Rows out | Reject % | SLA | Status |
|---|---|---|---|---|---|---|---|
| R-2201 | 2026-08-12 02:00:00 | 1980s | 2,400,000 | 2,400,000 | 0% | Met | healthy |
| R-2200 | 2026-08-11 02:00:00 | 2044s | 2,380,000 | 2,380,000 | 0% | Met | healthy |