Forum Discussion
Solved
Multiple Fact Tables also act as Lookup Tables
If I have two tables, one with Opportunities and one with Sales where there is already an established link (the opp id), is there best practice for handling when these data tables also act as lookup ...
Is the relationship that you refer in the post a many-to-many or a one-to-many, if it's a one-to-many then you just need to use the values from the one side two make the context and then add the data from the other table. If this is a many-to-many, I believe the best option is to create a bridger table with distinct values to pick up the information from both the tables.
MFelix
Super User
Super User
Is the relationship that you refer in the post a many-to-many or a one-to-many, if it's a one-to-many then you just need to use the values from the one side two make the context and then add the data from the other table. If this is a many-to-many, I believe the best option is to create a bridger table with distinct values to pick up the information from both the tables.