Kimball Forum
Would you like to react to this message? Create an account in a few clicks or log in to continue.

NULL DATES IN FACTS

2 posters

Go down

NULL DATES IN FACTS Empty NULL DATES IN FACTS

Post  SathyJaanu Tue Jan 19, 2016 3:01 pm

HI ,

we have few Date columns as Fact .Null's are replaced by default dates '1899-12-31'.
Our users are using tableau for self service reports now and they are finding it pretty hard to replace '1899-12-31' with null's in reports.
To avoid this can i have the date's as null in the Fact tables?
Is this the correct way of doing it?

please advise.

Thanks

SathyJaanu

Posts : 20
Join date : 2015-10-07

Back to top Go down

NULL DATES IN FACTS Empty Re: NULL DATES IN FACTS

Post  ngalemmo Tue Jan 19, 2016 3:53 pm

It depends. What is the date used for?

For example, if the date is used as part of a pair of effective and expiration dates, it is common practice to set a default value as null values do not evaluate properly when performing a BETWEEN.

If it is the timestamp of the event the row represents, having NULL may be correct as it truly reflects what is known about the date.

There is no standard here. It is dependent on the situation.
ngalemmo
ngalemmo

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

http://aginity.com

Back to top Go down

NULL DATES IN FACTS Empty Re: NULL DATES IN FACTS

Post  SathyJaanu Tue Jan 19, 2016 4:56 pm

Thanks for your inputs

SathyJaanu

Posts : 20
Join date : 2015-10-07

Back to top Go down

NULL DATES IN FACTS Empty Re: NULL DATES IN FACTS

Post  Sponsored content


Sponsored content


Back to top Go down

Back to top

- Similar topics

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