Data quality checks
Posted on 2016-10-18
I need to do data quality checks soon writing sql. I have the understanding of doing the following test types
1)validity -if the field is populated or not, if it has valid values or not
2)completeness-null or blank occurrences
First steps I am thinking of is doing data profiling on specific fields that I will be performing data quality test that I know if it allows null values or not..Any specific questions I should ask the team that is been doing testing(They haven't given me walkthrough and they wont too but I just want to ask intelligent questions regarding data quality testing)
Anything else that I should do to make sure the data quality test is done properly.
Thanks in advance.