What is Factless Fact Table? 🤔🤔🤔
A factless fact table is a type of table in a data warehouse that captures events or activities without any numerical values or measurable quantities. Essentially, it records the occurrence of events that have no associated metrics but still provide valuable information for analysis.
Here's a simple breakdown:👇👇👇
Purpose: To track events or relationships.
Contents: Contains only keys that reference dimensions (like date, product, customer, etc.) and no numerical facts (like sales amount, quantity, etc.).
Hope this helps, 100 % asked Interview Question ⬆️⬆️⬆️