A fact table that does not contain any measure is called a fact-less fact. This table will only contain keys from different dimension TABLES. This is often USED to resolve a many-to-many cardinality issue.

Explanatory Note: Consider a school, where a single student may be taught by many teachers and a single teacher may have many students. To model this situation in dimensional model, one MIGHT introduce a fact-less-fact table joining teacher and student keys. Such a fact table will then be able to answer queries like,

1. Who are the students taught by a SPECIFIC teacher.
2. Which teacher teaches MAXIMUM students.
3. Which student has highest number of teachers.etc. etc.

A fact table that does not contain any measure is called a fact-less fact. This table will only contain keys from different dimension tables. This is often used to resolve a many-to-many cardinality issue.

Explanatory Note: Consider a school, where a single student may be taught by many teachers and a single teacher may have many students. To model this situation in dimensional model, one might introduce a fact-less-fact table joining teacher and student keys. Such a fact table will then be able to answer queries like,