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