BrainTrust Investment Lab › Band 4 — Managing the ETL Environment
Band 4 — Managing the ETL Environment · book 485-486 · grain: one station per walk sheet
Everything that lands is recoverable — the raw arrivals, the staged work, the record itself. Losing a disk should cost hours, never history.
No walk sheets yet — this station begins when the ladder reaches it. Nothing is walked ahead of the lowest incomplete rung.
The contract — what each step must produce
| # | step | page | what the book requires |
|---|---|---|---|
| 2 | what is backed up, and why not everything | p.485 | 'This includes backing up the intermediate staging data necessary to restart failed ETL jobs.' And: 'The backup for the warehouse is usually a… |
| 3 | the book's three, answered honestly | p.485 | 'High performance... Simple administration... Automated, lights-out operations.' |
| 4 | the verb, PERFORMED | p.485 | 'Its goal is to allow the data warehouse to get back to work after a failure.' |
| 5 | what leaves, and can it still be read | p.486 | 'Will you be able to read that media in future years?' |
| 6 | readable without the application | p.486 | 'you may need to “sunset” the data by extracting it from the system and writing it in a vanilla format that is independent of the original… |