Joining fact tables
4 posters
Page 1 of 1
Joining fact tables
I have a order fact table. I have a call fact table. For each order, there is a call associated with it. Would I have the call id on the order fact and to join the 2 facts?
dellsters- Posts : 39
Join date : 2009-02-11
Re: Joining fact tables
Just curious, but why do you need to join the 2 fact tables? If you need to join them on more that a very infrequent basis, why would you simply put which ever dimensions you need on 1 fact table on the other fact table?
Jeff Smith- Posts : 471
Join date : 2009-02-03
Re: Joining fact tables
I'm assming dellsters is referring to degenerate dimensions. In a sales order model is it very rare you would have or need an Order dimension... same thing with call logs.
Similar topics
» Joining Fact tables
» Joining fact tables
» Joining two Fact tables???
» DegenerateDimension joining Fact tables
» Joining/Relating Fact Tables
» Joining fact tables
» Joining two Fact tables???
» DegenerateDimension joining Fact tables
» Joining/Relating Fact Tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum