snapshot fact table with multiple periods

View previous topic View next topic Go down

snapshot fact table with multiple periods

Post  alarge23 on Wed Sep 29, 2010 2:57 pm

I am new to designing star schemas and have what I'm sure is a fundemental question....

My users need 2 different periodic snapshots: 1 weekly and 1 monthly. It is the same data elements being collected, just at different points in time. Is there anything wrong with putting weekly/monthly measurements into the same Fact table and just use 1 date_dim table (with some kind of indicator to know if it is weekly or monthly)?

alarge23

Posts : 1
Join date : 2010-09-29

View user profile

Back to top Go down

Re: snapshot fact table with multiple periods

Post  ngalemmo on Wed Sep 29, 2010 4:25 pm

Yes, there is a problem with that. It complicates queries for no real benefit. Don't mix grains in a fact table. Two fact tables and share the same dimension tables.
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