Forum Discussion
Solved
Switching relationships between tables but USERELATIONSHIP has limitations (data modeling problem)
Question: is there any other "tool" than USERELATIONSHIP that we could use to allow switching from the Active to the Inactive relationships in the data model? The problem: my team is responsible for...
In my opinion, instead of relying on USERELATIONSHIP, you can use a bridge table that can switch between the historical and current dimensions.
Another approach you can split the fact table into two separate tables one for current data and one for historical data.
AmiraBedh
Super User
Super UserIn my opinion, instead of relying on USERELATIONSHIP, you can use a bridge table that can switch between the historical and current dimensions.
Another approach you can split the fact table into two separate tables one for current data and one for historical data.
Thanks for the ideas. How does a bridge table work in this case? Can you please point me to a sample or write up?