Saturday, June 1, 2013

[SQL Server Data Warehousing] How to create factless fact table?


I had a similar table in a transaction system that eventually the users wanted to measure time between events.


I create a Fact table that has Date and Time dimension tables linked to it as well as Minute Difference columns in the fact table. The ETL handled the calculations and 5-6 rows in the Registration transaction table became one row in the RegFact table.


CREATE TABLE (fact.Registration)


( RegID int, EnterQueueDateID int, EnteredQueueTimeID int, MarkAtDeskDateID int, MarkAtDeskTimeID int, EnteredQueueMarkAtDeskMinutes int...)


)


Instead of a factless fact, we had minute difs in the table. If i had other columns for the fact table, they became dimensions like Office, Recruiter, etc.


Thomas



TheSmilingDBA Thomas LeBlanc MCITP 2008 DBA



.

social.technet.microsoft.com/Forums

No comments:

Post a Comment

Search This Blog