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

Does it possible to have a Many-to-One relationship between two dimension tables?

2 posters

Go down

Does it possible to have a Many-to-One relationship between two dimension tables? Empty Does it possible to have a Many-to-One relationship between two dimension tables?

Post  thomaszhwang Mon Aug 22, 2011 3:09 pm

I know generally it should be a Many-to-Many relationship between two dimension tables. Does it possible to have a Many-to-One relationship between two dimension tables?

Thanks.

thomaszhwang

Posts : 32
Join date : 2011-08-11

Back to top Go down

Does it possible to have a Many-to-One relationship between two dimension tables? Empty Re: Does it possible to have a Many-to-One relationship between two dimension tables?

Post  liao Thu Aug 25, 2011 3:48 am

the two demension tables can be combined in one.
just like employee and department demension, if you get the employee, you also know the department who belongs to.

liao

Posts : 4
Join date : 2011-06-22
Location : Shanghai China

Back to top Go down

Does it possible to have a Many-to-One relationship between two dimension tables? Empty Re: Does it possible to have a Many-to-One relationship between two dimension tables?

Post  thomaszhwang Thu Aug 25, 2011 10:05 am

In your example, what if there is another fact table needs to be connected to a department dimension?

thomaszhwang

Posts : 32
Join date : 2011-08-11

Back to top Go down

Does it possible to have a Many-to-One relationship between two dimension tables? Empty Re: Does it possible to have a Many-to-One relationship between two dimension 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