Handling peak time by location

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.


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.

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

View user profile 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