Dealing with empty/missing dates in dimensions
Andrea Vincenzi at 15h22
20
Aug
2009
Dealing with empty/missing dates in dimensions
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 be left Null: Design Tip N° 43 suggests to replace them with values like "Unknown" or "Not provided", but doesn't tell us what to do in case of date fields.
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 be left Null: Design Tip N° 43 suggests to replace them with values like "Unknown" or "Not provided", but doesn't tell us what to do in case of date fields.
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 : 8714
- Numbers of users : 3801
- Numbers of points : 1672
Similar topics
Hello,
I am new to DW. Currently, I am working on a Human Resource database. There are many tables in the source systems which stores dates e.g. dates about contract start, finish, Vacations of an employee, temporary service suspension and many more.
One proposed model for our business (wholesale/retail) sales fact is to have every register ring in one fact.
This causes refunds, voids, coupons and other 'facts' to be stored in a single fact entity.
There is a column type dimension that then tells us
Hi All,
Our OLTP system supports effective dated concept. So users can enter Future Dated Rows also. And in our Warehouse we have both Type1 Dimesnions and Type2 Dimensions.
When loading the data to Type1 dimesnions, if we load future dated row
A recent acquisition has added complexity to the Customer dimension and associated fact tables at the company I work for. The root of the problem is that we now have around 20 sources of customer and associated sales facts. We have data quality processe
I have a bunch of date dimensions, such as BaselineDate, TargetDate, etc... I created role-playing views over my Date dimension for each of the different types of dates.
But each fact row will have a StartDateID and a FinishDateID for each (like
Forums from same category
HmongThoobNtiajTeb. com/
LEGO Island Discussion, modding, news and more!
Free forum : hi. Free forum : 2709rsgamboa6219. Free forum,
Free forum : Forum IT Teknik Komputer dan Jaringan SMKN 1 SLAWI
Techy Boards, a growing technology discussion forum! For fans of nintendo, xbox, playstation or anything else!
Search
See also
Informations
4 Replies For the topic :
"Dealing with empty/missing dates in dimensions"
This topic has been viewed 1669 times.
Last message :
20/08/2009 at 15h22 by "Andrea Vincenzi"
