How to handle date field with a null value in the fact table ?

View previous topic View next topic Go down

How to handle date field with a null value in the fact table ?

Post  esreis on Fri Jun 07, 2013 3:47 pm

I am developing a solution for the analysis of invoices.

My fact table is structured like this:

fact_invoice
----------------
SupplierKey
CustomerKey
.
. (other fields)
.
Price
EmissaoDatekey
CancelDateKey

My question is about how to treat the field CancelDateKey that also has null values​​.


esreis

Posts : 3
Join date : 2013-04-29

View user profile

Back to top Go down

Re: How to handle date field with a null value in the fact table ?

Post  BoxesAndLines on Fri Jun 07, 2013 6:21 pm

Treat it the same way as you would any other dimension, set to the default row value.
avatar
BoxesAndLines

Posts : 1212
Join date : 2009-02-03
Location : USA

View user profile

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