I have a Fact 1 joining to Dim1
Dim1 is joining to D2 ( one to many ) many is D2 side
Dim2 is joing to Dim3 table (many to one) many is D2 side.
basically D2 is a bridge table between D1 and D3
How to model these tables , any suggestions ?? where to create determinants ?
thanks in advance