Null and Blank Dates from Source System

Hi All,

I wanted to know what is the recommendation for dates in the DWH where they are feeding through
from source system as nulls or blanks?

Currently we do not have a consistent solution as some of the date columns are used in a composite key
and where they feeding through as a null or blank they converted to 01/01/1900.

Thanks

Normally it's handled by a date dimension. You simply have entries in the dimension for null and blank dates.

I also design my dimensions with a single varchar natural key, and use an NVL() function when building the key. This allows you to handle nulls and values that don't conform to the native data type.

In your particular example I'm not sure how this data is structured. There appears to be a 1:1 relationship between the records in each table - is this correct or is this just because of the data examples you've given?

http://www.pass-4sure.org