BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 469-470 · grain: one dimension per walk sheet
Provider identifiers get reused, recycled, and reorganized — tickers, CIKs, and CUSIPs all drift. Every dimension row gets its own permanent key, minted here, so the star's joins never depend on someone else's housekeeping.
completed
0 of 1
running now
dim_security
completedrunningawaiting its turn · owedfailedexcluded
The contract — what each step must produce
| # | step | page | what the book requires |
|---|---|---|---|
| 2 | the generator, declared | p.469 | 'The surrogate key generator should independently generate surrogate keys for every dimension; it should be independent of database instance and able… |
| 3 | the key carries nothing | p.470 | 'Avoid the temptation of concatenating the operational key of the source system and a date/time stamp. Although this approach seems simple, it is… |