Link two fact tables with many to many relationship

View previous topic View next topic Go down

Link two fact tables with many to many relationship

Post  Henar Safwat on Wed Feb 06, 2013 5:49 am

Dear all,

I have two fact tables ,each one connected with number of dim tables.the problem is i need to link those two fact tables as the relation between those fact tables is many-to-many relationship .the new table contain the surrogate key for the other two tables and a key from other dimension.how can i do that ???? thanks in advance for your help .

Henar Safwat

Posts : 8
Join date : 2013-02-06

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  BoxesAndLines on Wed Feb 06, 2013 12:29 pm

http://www.kimballgroup.com/2005/06/03/design-tip-68-simple-drill-across-in-sql/
avatar
BoxesAndLines

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

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  Henar Safwat on Thu Feb 07, 2013 3:05 am

Thanks for your help ,but i don't have to make a query against the two fact tables .
in my case i have two fact tables Circuit and Order the relation between them M-M .i want to create an intermediate fact table to capture the changes occurs on those fact tables ,the new fact table will be Circuit-Order which have another dimensions .how can i handle this case????????????


Last edited by sara Dakrory on Thu Feb 07, 2013 3:13 am; edited 1 time in total (Reason for editing : More clearing)

Henar Safwat

Posts : 8
Join date : 2013-02-06

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  ngalemmo on Thu Feb 07, 2013 7:40 am

Are you saying rows will be placed in the circuit/order table as the result of updates to either circuit or order? Or are you building circuit/order as an aggregation of the other two facts?
avatar
ngalemmo

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

View user profile http://aginity.com

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  Henar Safwat on Sun Feb 10, 2013 6:57 am

it's an aggregation with the two facts with another dimensionless on it this new fact .

Henar Safwat

Posts : 8
Join date : 2013-02-06

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  sara admin on Sun Feb 10, 2013 9:29 am

sara admin wrote: i think you mean that the new fact table Circuit -Order will contain the keys form the two fact tables and attribute and no measures will exist .

sara admin

Posts : 4
Join date : 2013-02-10

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

Post  Jeff Smith on Mon Feb 11, 2013 4:55 pm

If 2 fact tables are joined together, doesn't that technically change the database from a Star Schema to a snow flake?

Jeff Smith

Posts : 471
Join date : 2009-02-03

View user profile

Back to top Go down

Re: Link two fact tables with many to many relationship

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