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

Discussion Group for the Dimensional Data Warehouse and Business Intelligence Community


Many to Many to Many relationship

2 posters

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

Go down

Many to Many to Many relationship Empty Many to Many to Many relationship

Post  DBAHeart Fri May 03, 2013 6:33 pm

Hi,

I considered a bridge table but I thought it would be less complicated to have 2 FACT tables. I would greatly appreciate any design advice on this relationship.

I have included at the top - a description of current transactional data and at the bottom the 2 fact tables. I am concerned that even with 2 fact tables, I have 2 different grains and because one is lower it is a many to many relationship

IO's (feedings) to milks type = M - M
Milk types and instances have a many to many relationship with Additives both on type and on measures such as calories, and amounts

DBAHeart

Posts : 3
Join date : 2013-03-20

Back to top Go down

Many to Many to Many relationship Empty Re: Many to Many to Many relationship

Post  cjrinpdx Thu May 16, 2013 1:51 pm

I'm having trouble following you. Could you restate your question?

cjrinpdx

Posts : 51
Join date : 2011-07-14
Location : Portland, OR

Back to top Go down

Back to top

- Similar topics

Kimball Forum :: Topics :: Dimensional Modeling and Data Architecture

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