Boolean flag in fact table

Imagine we have received the results of a health survey on daily consumption habits of 3 different items, like the following:

Id	Date	Age	Country	CigarettesPerDay	CoffeesPerDay	BeersPerDay
1	2021-12-31	35	US	0	3	0
2	2021-12-31	22	US	5	5	1
3	2021-12-31	53	US	3	4	0
...	...	...	...	...	...
11276	2021-12-31	44	France	3	4	0

Asked by user252479 (31 )
May 14, 2022 at 11:11

---

Upvotes +0

Solution

It's not really an answer, but in lack of good ideas, I decided to put the flag in a dimension table after all.

Solved by user252479 (31 )
Jul 27, 2022 at 21:32

---

References

• https://dba.stackexchange.com/questions/312122

---