Mutiple Factless facts

View previous topic View next topic Go down

Mutiple Factless facts

Post  sneevand on Mon Jul 20, 2015 7:34 pm

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







sneevand

Posts : 1
Join date : 2015-07-20

View user profile

Back to top Go down

Re: Mutiple Factless facts

Post  ngalemmo on Mon Jul 20, 2015 8:28 pm

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

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

View user profile http://aginity.com

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