Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

Joining fact tables

4 posters

Go down

Joining fact tables Empty Joining fact tables

Post  dellsters Fri Feb 25, 2011 11:33 am

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

Back to top Go down

Joining fact tables Empty Re: Joining fact tables

Post  ngalemmo Fri Mar 04, 2011 1:09 pm

Or the order id on the call. Whichever works for you.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Joining fact tables Empty Re: Joining fact tables

Post  Jeff Smith Fri Mar 04, 2011 1:45 pm

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

Back to top Go down

Joining fact tables Empty Re: Joining fact tables

Post  ngalemmo Fri Mar 04, 2011 5:36 pm

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.
ngalemmo
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

http://aginity.com

Back to top Go down

Joining fact tables Empty Re: Joining fact tables

Post  rmorrison100 Mon Mar 07, 2011 3:15 am

Thanks for the information.

rmorrison100

Posts : 1
Join date : 2011-03-06
Age : 38
Location : FL

http://www.numerologist.com/articles/numerology/name-numerology/

Back to top Go down

Joining fact tables Empty Re: Joining fact tables

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum