What is Factless Fact Table?

 In the real world, it is possible to have a fact table that contains no measures or facts. These tables are called “Factless Fact tables”.

Eg: A fact table which has only product key and date key is a factless fact. There are no measures in this table. But still you can get the number products sold over a period of time.

The Customer fact is a fact less fact, it’s just links keys of dimensions.

Here is one typical Fact table with fact.