BrainTrust Investment Lab › Band 3 — Loading (Delivering to the Kimball STAR)
Band 3 — Loading (Delivering to the Kimball STAR) · book 478-479 · grain: one station per walk sheet
Financial data arrives late as a matter of routine — filings amended, figures restated. Late rows are placed into history where they belong, keys corrected retroactively, never appended where they would be convenient.
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 | search back for the keys that were in effect | p.478 | 'This is a messy situation because you have to search back in history to decide which dimension keys were in effect when the activity occurred. In… |
| 3 | the two situations, BOTH answered | p.479 | 'the ETL system needs to support two situations... if you believe the customer is a valid, but not yet processed customer, you should assign a new… |
| 4 | the update does not stop at the insert | p.479 | 'you need to scan forward in the dimension to see if there have been any subsequent type 2 rows for this customer and change this column in any… |
| 5 | changing history is an EVENT | p.478 | 'In a heavily compliant environment, it is also necessary to interface with the compliance subsystem because you are about to change history.' |