Data Architect Question: Download Data Architect PDF
Tell me your idea regarding factless fact? And why do we use it?
Answer:
Factless fact table is a fact table that contains no fact measure in it. It has only the dimension keys in it.
At times, certain situations may arise in the business where you need to have factless fact table. For example, suppose you are maintaining an employee attendance record system, you can have a factless fact table having three keys.
At times, certain situations may arise in the business where you need to have factless fact table. For example, suppose you are maintaining an employee attendance record system, you can have a factless fact table having three keys.
| Previous Question | Next Question |
| Explain me what is your understanding of different data models? | What is the logical model? |