Forum Discussion
Solved
Data Modelling Issue (Many to Many between Fact and Dimension)
Hello , Please help with the below data modelling question- I have a fact table called purchase Order and few other dimensions connected in star schema . Now I have brought in a connection t...
Hi,
try creating a bridge/factless fact table it will solve your many to many relationship problem.
if your don't know about bridge/factless fact table you can search on google that how to build one and what are the use cases of it.I hope this is helpfull
thank you
Hi,
try creating a bridge/factless fact table it will solve your many to many relationship problem.
if your don't know about bridge/factless fact table you can search on google that how to build one and what are the use cases of it.
I hope this is helpfull
thank you