Handling Null Values in Facts

View previous topic View next topic Go down

Handling Null Values in Facts

Post  BIDW on Thu May 21, 2015 1:22 am

Guys,

I understand that we should have a surrogate key called 0 in our dimension tables to handle null values. I have a scenario where a certain data is available at a later stage. How can i create a record in the date dimension which just mentions data not available.

I mean where should this description go? What should be the value for calendar date in this scenario. Any one who could share a sample would be great. Thanks.


BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Handling Null Values in Facts

Post  nick_white on Thu May 21, 2015 2:44 am

It's entirely up to you what values you put in the columns of your 0 Key Date dimension record.
You should consider how these values will appear in your reports, when they select records from facts that link to this 0 record and other non-0 records, and therefore what values will make sense to your end-users.
Obviously you are constrained by the datatype of the columns as to the values you can put in - assuming that you have a BI tool on top of your DW there may be opportunities to mask these column values with more user-friendly values

Regards

nick_white

Posts : 366
Join date : 2014-01-06
Location : London

View user profile

Back to top Go down

Re: Handling Null Values in Facts

Post  BIDW on Tue May 26, 2015 1:20 am

Thanks Nick. That sounds like a good suggestion.

Hunain

BIDW

Posts : 25
Join date : 2015-01-18

View user profile

Back to top Go down

Re: Handling Null Values 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