BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 479-480 · grain: one station per walk sheet
Conformed dimensions are published like software: versioned releases, one publisher, every subscriber on the same edition. No two reports disagree because they joined different copies of the truth.
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 | one conformed dimension, one source | p.479 | 'A conformed dimension is by necessity a centrally managed resource: Each conformed dimension must have a single, consistent source.' |
| 3 | the six, made MECHANICAL | p.480 | 'Update the version number of the dimension if any type 1 or type 3 changes are made... Replicate the revised dimension simultaneously to all fact… |
| 4 | the version is in every row -- and drill-across uses it | p.480 | 'This version number should be utilized to support any drill-across queries to assure that the same release of the dimension is being utilized.' |
| 5 | simultaneous, or declared otherwise | p.480 | 'the dimension manager must carefully manage the simultaneous release of new versions of the dimension to every fact provider' |