Null value for dates
Jeff Smith at 17h08
20
Dec
2010
Null value for dates
All of my dimension tables have a value -1 that means there was no match to then dimension table. I try to put in some value such as "Unknown" or "Not available".
Any suggestions for the -1 row in a Date dimension? Should I use some future date such as 12/31/9999? And if I use 12/31/9999, should I continue to use -1 as the default value? I tend to use the Date Dimension Key when caluculating the number of days between 2 dates on a fact, such a
All of my dimension tables have a value -1 that means there was no match to then dimension table. I try to put in some value such as "Unknown" or "Not available".
Any suggestions for the -1 row in a Date dimension? Should I use some future date such as 12/31/9999? And if I use 12/31/9999, should I continue to use -1 as the default value? I tend to use the Date Dimension Key when caluculating the number of days between 2 dates on a fact, such a
About
This topic belongs to the forum
Data Warehousing and Business Intelligence based on dimensional modeling and the Kimball Lifecycle.
- Numbers of topics : 1858
- Numbers of messages : 8713
- Numbers of users : 3801
- Numbers of points : 1613
Similar topics
I'd like to know other people's opinions on how to deal with missing dates in dimensions, which is a situation that happens quite frequently (for example, think of birth date in a customer dimension).
We all know that attributes in dimensions should not
Dear all,
I'm wondering if anyone could help me out with the following (simplified) case. This is for my Business Intelligence study on a Dutch university where we do a project to apply BI to the student information systems, especially their results an
Hello all,
While populating Effective End Date (Valid to date) for current record, is it better to put a largest possible end date value of 12/31/9999, or is it better to insert a null value. One advantage of inserting 12/31/9999 as end date is that
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
Hi all,
i read all the post and design tips about null values management.
Can you tell m if the following statements are right or wrong for you :
Dimension attributes null values management :
For string dimension attributes, use :
"Not
Forums from same category
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
LEGO Island Discussion, modding, news and more!
HmongThoobNtiajTeb. com/
Search
See also
Informations
10 Replies For the topic :
"Null value for dates"
This topic has been viewed 1186 times.
Last message :
20/12/2010 at 17h08 by "Jeff Smith"
