This blog provides information, news, tips, and announcements about the SQL Server Data Quality Services (DQS) feature introduced in SQL Server 2012.
Null, space, dummy, “unknown”, 99999, empty. All these small and innocent words represent missing data that may have a bad impact on our business execution and analysis.
So how DQS addresses the case of missing information?
This concludes our discussion on Null Values .
Now go out and hunt them down !!!
"If you want, you can set the DQS_NULL and all the null equivalence values as invalid, or set a domain rule that will set them to Invalid. "
Do you have any examples of domain rules that set a null value as invalid ? I'm afraid that patterns and regular expressions are not working well in this case.