What is the purpose of “Factless Fact Table”? How it is involved in Many to many relationship?
Factless fact contains only the key fields and any related dimensional bridge attributes. Doesn’t contain actual measure fields that are used for aggregates or summary. Factless facts can be used as a bridge tables or to store measures that are used directly without aggregation(for e.g. max(), min() attributes)