Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

snapshot fact table with multiple periods

2 posters

Go down

snapshot fact table with multiple periods Empty snapshot fact table with multiple periods

Post  alarge23 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

Back to top Go down

snapshot fact table with multiple periods Empty Re: snapshot fact table with multiple periods

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

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

http://aginity.com

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum