Factless Fact Table

Remember from the basic example that a fact table contains the objects that are measured (called facts) by a star or snowflake schema. There is a type of fact table that contains no measures. This type is called a factless fact table. A factless fact table simply records the occurance of an event. The FACT_HELPDESK_TICKET table is an example of that. This table does not measure anything about the help desk tickets. It simply records each instance of a help desk ticket. Like a fact table, a factless fact table contains a composite primary key, which is the combination of the foreign keys.