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.
0 comments: