BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 480-481 · grain: one station per walk sheet
The other half of the publishing contract: every fact table subscribes to the dimension releases and restates its aggregates when an edition changes. The numbers you compare were built to be comparable.
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 dimension arrives -- and postdated rows are handled | p.480 | 'the fact provider must process dimension records marked as new and current to update current key maps in the surrogate key pipeline and also process… |
| 3 | new rows, and the THREE correction causes | p.480 | 'Modify rows in all fact tables for error correction, accumulating snapshots, and late arriving dimension changes.' |
| 4 | remove, recalculate -- the VERSION decides which | p.480 | 'If the new release of a dimension does not change the version number, aggregates have to be extended to handle only newly loaded fact data. If the… |
| 5 | satisfy yourself the aggregates are right | p.481 | 'Quality ensure all base and aggregate fact tables. Be satisfied the aggregate tables are correctly calculated.' |
| 6 | the inconsistent aggregate comes DOWN | p.481 | 'The fact provider (subsystem 18) is responsible for taking aggregates offline when they are not consistent with the base data.' |
| 7 | the users are told what changed | p.481 | 'Inform users that the database has been updated. Tell them if major changes have been made, including dimension version changes, postdated records… |