BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 477-478 · grain: one station per walk sheet
When a fact honestly belongs to many parties — one filing, three registrants — we build the bridge table the book prescribes, weights and all, rather than double-counting or quietly picking a winner.
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 grain cannot absorb it | p.477 | 'If the grain of the fact table cannot be changed to directly support this dimension, then the multivalued dimension must be linked to the fact table… |
| 3 | unique or reused -- and the book says it is hard | p.477 | 'the ETL system has the choice of either making each set of observations a unique group or reusing groups when an identical set of observations… |
| 4 | declared, or honestly absent | p.478 | 'in other cases, the identification of the appropriate weighting factor can be problematic because there may be no rational basis for assigning the… |
| 5 | if the members are type 2, the bridge is dated | p.477-478 | 'In the event the multivalued dimension has type 2 attributes, the bridge table must also be time varying, such as a patient’s time variant set of… |