Mutiple Factless facts
2 posters
Page 1 of 1
Mutiple Factless facts
Hi,
We have an star schema, which has 5 different fact less fact which are just used to find the count for each category of the products. X product type count no of orders, Y Product type orders; based on different dates and different product types.
FactRootsByOrderdate
FactFailuresByOrderdate
FactTradedbyOrderDate
FactSoldByOrderDate
How can I combine all the factlessfacts to single table with jus including and category Type as Root,Failure,Trade,Sold; Does it impact the performance?
Consider for some dates; some category don't have data.
Does it provide me accurate count as now?
Regards,
Navin
We have an star schema, which has 5 different fact less fact which are just used to find the count for each category of the products. X product type count no of orders, Y Product type orders; based on different dates and different product types.
FactRootsByOrderdate
FactFailuresByOrderdate
FactTradedbyOrderDate
FactSoldByOrderDate
How can I combine all the factlessfacts to single table with jus including and category Type as Root,Failure,Trade,Sold; Does it impact the performance?
Consider for some dates; some category don't have data.
Does it provide me accurate count as now?
Regards,
Navin
sneevand- Posts : 1
Join date : 2015-07-20
Re: Mutiple Factless facts
Or you can have one table with count measures for each of the categories (probably containing 1 or zero). This would give you the same number of rows as your other tables so it should not significantly affect performance.
How your particular DBMS handles the larger table you propose, and how you tune it, will determine how it would perform. At worst it would be a linear increase (4x bigger, 4x longer) or it may not matter at all.
How your particular DBMS handles the larger table you propose, and how you tune it, will determine how it would perform. At worst it would be a linear increase (4x bigger, 4x longer) or it may not matter at all.
Similar topics
» Combining Factless Facts and Bridges - sensible or not?
» Fact Tables Joining to Factless Facts
» how to handle mutiple level granularity in retail domain dimensional model
» Multiple Facts or Single Facts and Status Table?
» How best to model Timesheet facts against Sales Order facts
» Fact Tables Joining to Factless Facts
» how to handle mutiple level granularity in retail domain dimensional model
» Multiple Facts or Single Facts and Status Table?
» How best to model Timesheet facts against Sales Order facts
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|