Link two fact tables with many to many relationship
5 posters
Page 1 of 1
Link two fact tables with many to many relationship
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 .
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
Re: Link two fact tables with many to many relationship
http://www.kimballgroup.com/2005/06/03/design-tip-68-simple-drill-across-in-sql/
BoxesAndLines- Posts : 1212
Join date : 2009-02-03
Location : USA
Re: Link two fact tables with many to many relationship
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????????????
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
Re: Link two fact tables with many to many relationship
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?
Re: Link two fact tables with many to many relationship
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
Re: Link two fact tables with many to many relationship
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
Re: Link two fact tables with many to many relationship
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
Similar topics
» Modelling parent-child relationship source tables to Fact with correct grain
» map M-M relationship between two fact tables
» Relationship between scd hierarchies and then between fact tables
» Can a Bridge Table also be used for mapping?
» Relationship between fact table and dimension tables
» map M-M relationship between two fact tables
» Relationship between scd hierarchies and then between fact tables
» Can a Bridge Table also be used for mapping?
» Relationship between fact table and dimension tables
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum