BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 481-482 · grain: one station per walk sheet
Cubes are served from the star, never beside it — the same conformed dimensions, the same facts, just faster to slice. One truth at several speeds, not several truths.
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 | built or REFUSED, and dated | p.482 | 'The relational dimensional schema should be viewed as the foundation for OLAP cubes IF YOU ELECT to include them in your architecture.' |
| 3 | the relational star is the ONLY source | p.482 | 'the relational schemas are the best and preferred source for OLAP cubes' |
| 4 | loaded LAST, because OLAP trusts | p.482 | 'Because many OLAP systems do not directly address referential integrity or data cleaning, the preferred architecture is to load OLAP cubes after the… |
| 5 | cubes are stricter than stars | p.482 | 'It is important to strongly enforce the integrity of hierarchies within dimensions before loading an OLAP cube.' |
| 6 | the passage the book tells you to read twice | p.482 | 'Type 1 SCDs that restate history do not fit OLAP well. Overwrites to an attribute value can cause all the cubes using that dimension to be… |