Header/line fact tables

Operational transaction systems often consist of a transaction header row that’s associated with multiple transaction lines. With header/lineschemas (also known as parent/childschemas), all the header-level dimension foreign keys and degenerate dimensions should be included on the line-level fact table.