BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 475-477 · grain: one fact table per walk sheet
The last gate before any fact lands: every natural key must exchange for a real dimension key. No match, no silent orphan — the row is caught at the door, and referential integrity holds by construction, not by an audit after the fact.
completed
0 of 1
running now
fact_price
completedrunningawaiting its turn · owedfailedexcluded
The contract — what each step must produce
| # | step | page | what the book requires |
|---|---|---|---|
| 2 | dimensions first, always | p.476 | 'To preserve referential integrity, always complete the updating of the dimension tables first. In that way, the dimension tables are always the… |
| 3 | every natural key resolves -- at the right VERSION | p.476 | 'select the surrogate key that aligns with the historical context of the fact row using the current row indicator or begin and end effect dates' |
| 4 | the failures are fed back, never dropped | p.476 | 'you need to feed these failures back to the responsible ETL process for resolution' |
| 5 | the duplicate row decision | p.477 | 'This is an example of a data quality problem appropriate for a traditional structure data quality screen, as discussed in subsystem 4... write an… |
| 6 | the fact row keeps only surrogates | p.477 | 'Don't keep the natural key in the fact row -- the fact table needs to contain only the surrogate key.' |