Friday, July 11, 2014

can we leave missing data as null when load source data into data warehouse?

No! 


because

NULL != NULL

Think about when you do a outer join and some NULL was created after outer join. Then, SQL programmers, who will create SQL query on aggregate tables, will not be able to identify the source of NULL.

No comments:

Post a Comment