Hello,
My problem is that I need to reduce the data of this two tables, that already related between them.
T1 (Fact):
Relation_ID
Security_ID1
T2(Dimension):
Relation_ID
Security_ID2
I have tryed with link tables, but the problem stays, if there is not a circular reference, the other issue is the double selection or relationship.
Do you know a solution?