Database Elaborations: Fact Tables and Their Lying Primary Keys

When working on a multidimensional design, every fact table within scope should be handled with care. In an ideal world, each low-level fact table represents the metrics related to a business event. The meaning of a fact table, ideally, should be evident based on the table name and the composition of the fact table’s primary key. Deciding on a primary key for a fact table is an important choice.