NULL DATES IN FACTS

View previous topic View next topic Go down

NULL DATES IN FACTS

Post  SathyJaanu on 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

View user profile

Back to top Go down

Re: NULL DATES IN FACTS

Post  ngalemmo on 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.
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 DATES IN FACTS

Post  SathyJaanu on Tue Jan 19, 2016 4:56 pm

Thanks for your inputs

SathyJaanu

Posts : 20
Join date : 2015-10-07

View user profile

Back to top Go down

Re: NULL DATES IN FACTS

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