In order to understand the use of Factless FACT table we have to refer to, Kimball Group, one of the earliest pioneers in the field of Data Warehouse. According toKimball Group, "It is possible that the event merely records a set of dimensional entities coming together at a moment in time...
but there may be no associated metrics.Factless fact tablescan also be used to analyze what didn’t happen. These queries always have two parts: a factless coverage table that contains all the possibilities of events that might happen and an activity table that...