BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 473-475 · grain: one fact table per walk sheet
Every fact table declares its grain before a single row loads — one row means exactly one thing, always. The three shapes the book allows are the only three we build, and a row that fits none of them does not load.
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 | which of the three, and why | p.473 | 'the three primary types of fact tables: transaction, periodic snapshot, and accumulating snapshot' |
| 3 | every fact true to the grain | p.473 | 'The facts in this transaction table must be true to the grain and should describe only what took place in that instant.' |
| 4 | partitioned by time | p.474 | 'In most cases, the target fact table should be partitioned by time to ease the administration and speed the performance of the table.' |
| 5 | the load can be resumed | p.474 | 'An audit key, sequential ID, or date/time stamp column should be included to allow backup or restart of the load job.' |
| 6 | insert then delete, never overwrite | p.474 | 'The first step is to insert the corrected rows without overwriting or deleting the original rows, and then delete the old rows in a second step.' |