Decision Walk: Handle a Late-Arriving Customer Dimension
Choose a disciplined path for late-arriving dimensions without corrupting fact history.
The lag Payments are available in near real time. Customer master data is not. The warehouse has to choose between timeliness and completeness. If you choose badly, either finance waits for money data or analysts read facts tied to mutable text. The framework Preserve the fact, infer the dimension Dimensional modeling keeps the event on time and lets the descriptive context catch up under control. Wait for perfect source data Sounds safe, but turns source lag into reporting lag. Timely facts with governed dimension completion. Separate event truth from descriptive completeness. Choose the first move 01 The customer record is…
Sign up free — one personalized lesson every day, matched to your role and goals.
Already have an account? Sign in