• Ryan,

    In my opinion there is no reason at all to not replace NULLs in your fact table by references to a 'N/A' record.

    I can see your management's point if you're talking about a table that is used in an OLTP environment, but in an OLAP environment NULL values in the dimension fields just make no sense.