Forum Discussion
two both direction between two fact table and two dimension table
Anonymous , if you have two facts and two dimensions, You can not have all bi-directional relationships. As it creates loops or multiple paths. Keep one of the dims in a single direction.
Bi-Directional joins are also not recommended because of performance reasons.
Anonymous , I think with one fact you should be able to do. The thing is that there should not be two paths or loops.
Say A- Fact - C
A- Fact2 - C
When it is bi-direction you have two paths
A- Fact - C - Fact2
A- Fact2
Super UserAnonymous , if you have two facts and two dimensions, You can not have all bi-directional relationships. As it creates loops or multiple paths. Keep one of the dims in a single direction.
Bi-Directional joins are also not recommended because of performance reasons.
Is it availble that all dimension tables has bi-directional relationship to only one fact table?
- amitchandak
Anonymous , I think with one fact you should be able to do. The thing is that there should not be two paths or loops.
Say A- Fact - C
A- Fact2 - C
When it is bi-direction you have two paths
A- Fact - C - Fact2
A- Fact2