The grain of a fact table
We all understand what a fact table is. What about the grain of a fact table?
The grain of a fact table is the definition of what constitutes a unique fact table record. In the dimensional-modeling world, the grain is always declared at the beginning of the design in business terms, not in database terms.
The grain of our insurance example could be insurance policy transaction.