BrainTrust Investment Lab › Band 2 — Transform (Cleaning & Conforming)
Band 2 — Transform (Cleaning & Conforming) · book 461-463 · grain: one conformed dimension per walk sheet
Twenty sources will disagree about what a company is. This station forges the one set of conformed dimensions every fact table shares — so fundamentals from filings and prices from the tape land on the same spine and finally mean the same thing.
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 | the bus matrix is READ, not written | p.463 | 'The conforming subsystem is responsible for creating and maintaining the conformed dimensions and conformed facts described in Chapter 4: Inventory.' |
| 3 | the conformed attributes, one at a time | p.461 | 'For two dimensions to be conformed, they must share at least one common attribute with the same name and same contents. You can start with a single… |
| 4 | the contents are MADE to match | p.461 | 'The data from these two customer sources needs to be conformed to make some or all the columns describing customer share the same domains.' |
| 5 | the row carries its own version | p.462 | Figure 19-3: 'Special contents: 1) dimension version number 2) back pointers to all source natural keys' |
| 6 | the falsifier, EXECUTED | p.461 | [house] the book's own test: two processes sharing an attribute with the same name and the same contents can be drill-across joined |