The key features of data quality rules
Now that data quality rules have been introduced, we will focus on the key features that must be taken into consideration when developing rules for the first time. The following diagram summarizes each of these features:
Figure 6.1 – A reference diagram for the key features of data quality rules
Each of these concepts needs to be considered when designing a data quality rule. It is important to understand the concepts well before starting the design process to avoid having to revisit every rule and retrofit them later on.
The remainder of this section will explain these concepts in depth and provide examples.
Rule weightings
Rule weightings are used to assign greater or lesser importance to certain rules. Greater weighting will be placed on critical rules. A data quality tool will use the provided weightings when calculating an overall data quality score, such as the following: