ST3 — TRUE Single Lake House · Progress Update
DWH Migration · Phase: Design · Gate: M1 Design Sign-off (Aug 14)
8%
Overall Project
1/12 Milestones
9d
to M1 Design
deadline Aug 14
1,861
Migration Jobs
CoreDW 1,688 · ODS 173
116/108
Issues
Open / Closed
True Single Lake — Schedule Timeline
Jul
Aug
Sep
Oct
Nov
Dec
Jan
Feb
Mar
M0
M1
Today
Assessment (done)
Design
Deploy
UT
SIT
UAT
Cust UAT
Parallel
Cut-Over
▌Today
⚠ Risk & Issue
OPEN
CDC Performance
Debezium (LogMiner) causes severe DB overhead. Requires 24-48h Archive Log retention; storage limited — crash risk.
OPEN
500TB Migration
Approach undecided: offline bulk vs GoldenGate. Blocks Design sign-off before Aug 14.
OPEN
Cutover Planning
E2E cutover by Business Group: wave, rehearsal, rollback. Target: end of Jan 2027.
OPEN
EA Alignment
IT Lead cannot endorse solution until EA alignment. If EA rejects, escalates back to IT Lead.
OPEN
Solution Change Alignment
DB direct: not used during parallel run; queries from staging (per K. Big); cut over to source direct after go-live.
OMX/OMXMF: align consumption or topic mirroring to replace Notilog from Kafka DA.
True LH Work ST3 — Status Report
| Stream |
VC Single Lakehouse |
Period |
31 Jul – 05 Aug 2026 |
| Overall Status |
On-Track |
| Executive Summary |
Design phase active — HLD/LLD and CDC strategy finalized. Migration inventory near-complete (19/20 dimensions, 15,812 lineage edges). 6 of 8 design gaps closed. M1 Design sign-off target Aug 14. |
| Sub-Stream |
True LH Work ST3 |
| Accomplishment |
- Migration inventory 19/20 dimensions complete (15,812 data flow edges, 25 OGG sources, 0 fabricated)
- Design gaps closed 6/8 — Surrogate Key, Data Type, DDL, Tier Testing, Framework Lead, +3
- ACL R1-R3 all closed — iSFTP→ITDP Landing tested, Disk 15TB LandingZone2 ready
- Resource naming complete — all 10 migration engineers named
- Framework 2/5 topics confirmed (Job Trigger, Ingest File)
|
| In Progress |
- Framework Topics 3+4+5 (NRT DB / Kafka CDC / Transform) — customer deadline Aug 07
- Historical 500TB migration design — approach decision needed Aug 08
- CDC PoC execution — result target Aug 12
- Archive log retention expansion — DBA coordination
|
Next Steps
- This Week — Data Type Mapping confirm (Oracle→Blendata)
- This Week — Framework Topics 3+4+5 close
- This Week — Historical 500TB approach decision
- Next Week — CDC PoC result + Archive log expansion
- M1 Week (Aug 14) — Design Sign-off
Source: WBS baseline · risk-register.md · assessment-checklist.md · migration-wave-design.md
ST3 PM · 05 Aug 2026 · M1 in 9 days