Link table with different dimensions for different Facts
I am trying to find out if it is possible to create a link table which will have 2 Fact tables with similar dimensions and keys, while the third Fact will not have the same set of dimension keys. is it possible to create a separate composite key just to connect the fact2 and fact3? Or is it possible to use the same key created for the Fact1 and 2 for joining Fact3 as well.
Re: Link table with different dimensions for different Facts
Yes, you can create a Link Table that connects different Facts with difference granularity levels. You will need to generate two Combo keys - one with all three common keys and another one with only the two common keys. Fact1 and Fact2 will be joined by the first key, while Fact3 will be joined by the second key.