Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, March 18, 2013 9:51 PM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, April 01, 2014 2:57 PM
Points: 443, Visits: 822
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