Many to Many Confusion

View previous topic View next topic Go down

Many to Many Confusion

Post  vishal4u on 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

View user profile

Back to top Go down

Re: Many to Many Confusion

Post  BoxesAndLines on 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
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Many to Many Confusion

Post  ngalemmo on 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.
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Many to Many Confusion

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

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