Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
What are the ways to resolve circular references ?
Is link table one of the ways used to resolve circular reference apart from renaming and removing common column?
As per my knowledge, link table can only be used to resolve synthetic keys
If renaming or removing columns works and keeps the expected functionality you should go for it.
Link tables and concatenating usually works for multiple fact tables.
There's a good article here.
