BrainTrust Investment Lab › SS5 — Error Event Schema › overview
overview — the SS5 walk
Company profiles from a commercial vendor — 5,405 snapshots of the market's own description of each firm. Vendor-computed figures are kept as mirrors, never as truth: we store what they said, and we mark that it is them saying it.
One source per sheet; every step CERTIFIED or OWED by BrainTrust Staff, matched against the book’s page.
steps certified
8 of 8
step schema · the star EXISTS, measured against Figure 19-1 -- and its DDL of record is named ✓ CERTIFIED · p.458
step screen_dim · every declared screen has ONE dimension row -- closed BOTH directions against… ✓ CERTIFIED · p.459
step batch · the run is ONE batch row, and the batch ENDS ✓ CERTIFIED · p.458
step date_key · the calendar date RESOLVES -- to a dimension that exists ✓ CERTIFIED · p.458-459
step grain · EXACTLY ONE ROW PER ERROR THROWN -- and every counted defect has its row ✓ CERTIFIED · p.458
step detail_grain · the LOWER grain -- one field, in one record, per detail row ✓ CERTIFIED · p.459-460
step populate · THIS LANE'S SCREENS WRITE -- in THIS run, by a writer that exists ✓ CERTIFIED · p.460
step tables · the lane's tables measured ✓ CERTIFIED · p.[house]