[
From SQL Server Magazine]
The arguments for and against NULL in the data warehouse are complicated. The goal of the data warehouse is to represent a single version of the truth for the enterprise. This article looks at a number of situations when use of NULL might be appropriate, and situations where the use of NULL could cause end user confusion.
The article continues at
http://www.sqlmag.com/Articles/ArticleID/100507/100507.html?Ad=1