Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

NULL Values in Fact Table

2 posters

Go down

NULL Values in Fact Table Empty NULL Values in Fact Table

Post  jimbo1580 Thu Jan 14, 2010 6:53 pm

In an Accumulating Snapshot that has multiple dates, where we are revisiting the fact rows as additional events occur, should the foreign keys to the date dimension for dates that have not yet occurred be set to NULL or should they point to a "dummy" row in the date dimension.

Thanks

jimbo1580

Posts : 23
Join date : 2009-04-30

Back to top Go down

NULL Values in Fact Table Empty Re: NULL Values in Fact Table

Post  amarpal Thu Jan 14, 2010 8:04 pm

Reference to an inferred (dummy) row in the Dim table is always preferred. Following are some of the reasons:
1. The where clause in the queries on the fact table doesn't need to consider null different from other values ("IS NULL" vs. "= Value").
2. The absence of a late arriving dimension value may be for multiple reasons and you can have one inferred (dummy) row in the Dim table for each of these reasons. These reasons will be visible in your reports based on what attribute values you store for the inferred row.

amarpal

Posts : 3
Join date : 2010-01-14

Back to top Go down

Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum