Building my first data warehouse. Advice welcomed :)

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Database Design » Design Ideas and Questions » Building my first data warehouse. Advice...

11 posts, Page 2 of 2

««1 2

Building my first data warehouse. Advice welcomed :)

Rate Topic

Display Mode

Topic Options

Author

Message

davoscollective

Posted Monday, March 18, 2013 9:51 PM

SSC-Addicted

Group: General Forum Members
Last Login: 2 days ago @ 12:34 AM
Points: 408, Visits: 686

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 »

11 posts, Page 2 of 2

««1 2

Permissions