Section Application related to a Fact and a Dimension that are already related.

[gines_rueda]

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?