Handling Null Values in Facts

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.

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

Thanks Nick. That sounds like a good suggestion.

Hunain