BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 481 · grain: one station per walk sheet
Summaries are performance tools, never a second version of the truth: every aggregate must reconcile to the base tables it summarizes. A rollup that cannot prove agreement does not ship.
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 | the slow query log, not an intuition | p.481 | 'a log of frequently attempted slow-running queries should be captured. You should also try to identify the nonexistent slow-running queries that… |
| 3 | what it rolls up, and which dimensions shrink | p.481 | 'the aggregation builder needs to populate and maintain aggregate fact table rows and shrunken dimension tables where needed by aggregate fact… |
| 4 | incremental is fastest, but not always allowed | p.481 | 'The fastest update strategy is incremental, but a major change to a dimension attribute may require dropping and rebuilding the aggregate.' |
| 5 | always consistent with the ATOMIC base | p.481 | 'Aggregates must always be consistent with the atomic base data.' |
| 6 | it can be destroyed and rebuilt | p.481 | 'Aggregations are like indexes; they are specific data structures created to improve performance.' |