Handling peak time by location

View previous topic View next topic Go down

Handling peak time by location

Post  gbaren on Thu Apr 03, 2014 11:03 am

How can build the ability to report on "peak periods" into my design?

Peak periods in my application are different for each location and even different on different days. On days before a holiday, they are like Fridays, on holidays, a Saturday or Sunday, etc.

I'm considering Peak as a degenerate dimension with a Y/N assigned by ETL but can't help wondering if there is a better way.


gbaren

Posts : 15
Join date : 2014-01-30
Location : 02

View user profile http://equalsql.wordpress.com

Back to top Go down

Re: Handling peak time by location

Post  ngalemmo on Thu Apr 03, 2014 12:10 pm

It depends. You could create a dimension whose natural key is location and date, but if the only attribute is the peak indicator, you are better off storing it as a degenerate dimension on the fact. If there are other attributes dependent on location and date (or expect such attributes in the future), it would be worthwhile to build a dimension table.
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