Forum Discussion
Dealing with more than one Fact Table using “Linked Table”
Create a model with more than one Fact Table is a common scenario, and usually we have to join these Fact Tables against a common set of dimensions. Common problems of this scenario are circular ref...
hi gipiluso,
Thanks for the solution. But I have a problem. I have 3 facts and 4 dim tables:
F1 - links to D1,D2,D3
F2 - links to D2,D3,D4
F3 - links to D3,D4
In this scenario, how do I set up the linked table ? Do I just create 1 broad linked table which (with columns linking to all Dimension tables) and has got distinct entries from each fact table, and NULLs where the dimensions are absent ?
thanks,
If you can create just one linked table i suggest to go for it