Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase ««12

Building my first data warehouse. Advice welcomed :) Expand / Collapse
Posted Monday, March 18, 2013 9:51 PM

Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Sunday, November 20, 2016 8:55 PM
Points: 559, Visits: 994
No need to have a separate fact table to store all those dates.

The ticket process is actually a perfect candidate for an accumulating fact table.
If you are interested in a current status snapshot of tickets, then a standard accumulating snapshot is ideal. You add in some extra fields for each of those dates on the fact table (date dimension FK's), and fill them as the information becomes available.

If the detailed history of each ticket change is required (as Jeff mentioned, tickets regressing in their status) then a Time stamping accumulated snapshot might be more appropriate, but this is overkill IMO.
Post #1432462
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse