SCD type 2 - Valid To Date Value? 12/31/9999 or Null?

kinu008 at 18h09
28
Apr
2010
SCD type 2 - Valid To Date Value? 12/31/9999 or Null?

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 oracle 'between' function can be used effectively while doing a search on date range.

I just want to find out if there are any drawbacks of inserting 12/31/9999 as

Read more
Reply
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
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
Best way to implement date ranges in schemas (fact 1 valid "from" date1 "to" date 2)
Greeting, I am roaming around the web and im not very successful in my research so i will ask here, hoping that someone smarter than me will be able to help! Basicly, I need to build a cube (and the underlying start schema) that will allow the user
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 suc
Data Cleaning - replacing nulls and addresses
Hi, I need to do some data cleaning as part of a data warehouse project that I'm about to start. Some of the tasks will include some basic data cleaning (e.g. handling of nulls & replacing with a default value). Then there will be more complex
SCD Type II Design Decision
Hi, I am fairly new to dimensional modelling and have been struggling with a problem for a couple of days now. I currently have a fact table which stores incidents/problems with orders that are sent to customers. The system from which this incident dat
Forums from same category
See also
more_less
Informations

2 Replies For the topic :
"SCD type 2 - Valid To Date Value? 12/31/9999 or Null?"

This topic has been viewed 1855 times.

Last message :
28/04/2010 at 18h09 by "kinu008"