Null and Blank Dates from Source System
3 posters
Page 1 of 1
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
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
Informer30- Posts : 8
Join date : 2010-07-05
Re: Null and Blank Dates from Source System
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.
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.
Re: Null and Blank Dates from Source System
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
http://www.pass-4sure.org
pinkrosi- Posts : 1
Join date : 2014-11-25
Similar topics
» Null value for dates
» NULL DATES IN FACTS
» Poorly sturctured data at source system
» Business Logic: DWH vs. Source system
» Recursive Relationships in Source System
» NULL DATES IN FACTS
» Poorly sturctured data at source system
» Business Logic: DWH vs. Source system
» Recursive Relationships in Source System
Page 1 of 1
Permissions in this forum:
You cannot reply to topics in this forum
|
|