Forum Discussion
Solved
Modelling options for multiple yes/no fields
We have a lakehouse table in our directly lake semantic model that has 5 flag fields containing a 1 or 0 for True/False respectively. We would like to keep them as integers as they are easier to aggr...
MarkBurgess I think that both 4 and 5 look good. The simplest is the two versions of each field. If it doesn't blow up your data model that's probably a good way to go. That said, 4 probably keeps the spirit of the star schema.
MarkBurgess I think that both 4 and 5 look good. The simplest is the two versions of each field. If it doesn't blow up your data model that's probably a good way to go. That said, 4 probably keeps the spirit of the star schema.
Thanks Greg_Deckler , the separate tables give users a choice between Y/N and Yes/No so might just bite the bullet and treat them as 'proper' dimensions. Appriciate your input.
