Data Quality reporting over time
We have a set up here at Speedy where we have data quality split across multiple spaces. We pull all of the DQ validations out into a central space via snapshots and views to create a kind of DQ datamart which enables us to report DQ at a company level. One of the key issues we are challenged with is that users can occasionally change the name of a DQ validation rule to make it more clear or even just correct a spelling. The problem is this effectively creates a new DQ rule in the datamart. Ideally the name of the DQ rule should not be the primary key for a DQ rule - it should have an ID and then the validation should be a transactional FACT. IS anyone else facing this issue and have they found a way of dealing with it?