I'm doing a little research into some issues we are having with a front-end BI tool and currently seeking some community feedback on NULL values in fact tables. Of course, outside the obvious of removing nulls from fact keys, I'm wondering:
Do you allow them in numeric fields? Or do you replace nulls from the source in ETL with zeros? I can imagine that each DW implementation is unique, but again, wanted some overall feedback on the advantages/disadv of NULLS in fact rows.