Null and Blank Dates from Source System

View previous topic View next topic Go down

Null and Blank Dates from Source System

Post  Informer30 on Thu Aug 28, 2014 10:31 am

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

Informer30

Posts : 8
Join date : 2010-07-05

View user profile

Back to top Go down

Re: Null and Blank Dates from Source System

Post  ngalemmo on Thu Aug 28, 2014 8:08 pm

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.
avatar
ngalemmo

Posts : 3000
Join date : 2009-05-15
Location : Los Angeles

View user profile http://aginity.com

Back to top Go down

Re: Null and Blank Dates from Source System

Post  pinkrosi on Tue Nov 25, 2014 2:55 am

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

pinkrosi

Posts : 1
Join date : 2014-11-25

View user profile

Back to top Go down

Re: Null and Blank Dates from Source System

Post  Sponsored content


Sponsored content


Back to top Go down

View previous topic View next topic Back to top

- Similar topics

 
Permissions in this forum:
You cannot reply to topics in this forum