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 Confusion

3 posters

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

Go down

Many to Many Confusion Empty Many to Many Confusion

Post  vishal4u Thu Apr 02, 2009 1:00 am

Hi,

Just wanted to know how we can overcome or resolve Many to Many Relationship in DWH.

Vishal

vishal4u

Posts : 1
Join date : 2009-04-02

Back to top Go down

Many to Many Confusion Empty Re: Many to Many Confusion

Post  BoxesAndLines Thu Apr 02, 2009 1:49 pm

Groupers if dimensional, associated entity is normalized.

http://www.intelligententerprise.com/print_article_flat.jhtml;jsessionid=34RA3B5ER4RBOQSNDLPCKHSCJUNN2JVN?article=/020812/513warehouse1_1.jhtml
BoxesAndLines
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

Back to top Go down

Many to Many Confusion Empty Re: Many to Many Confusion

Post  ngalemmo Mon May 18, 2009 5:28 pm

An associative entity (aka: fact table, bridge table) is equally useful in a dimensional model to resolve many-to-many relationships (actually the grouper approach uses an associative entity too.)

Not everthing works with groups. For example the relationship between titles and authors and royalty rates is not modeled using groupings.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

Many to Many Confusion Empty Re: Many to Many Confusion

Post  Sponsored content


Sponsored content


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