We would like to be able to see if referential integrity is turned off/on for tables.
Business case: A data governance team may be analyzing a table and its field for quality and using the D360 tool they determine that a crucial relationship in the data model is not being enforced in the database. This gives the opportunity for key orphans to exist in either table in the relationship and informs them that they should perform deeper analysis for data cleanup and ongoing monitoring if RI cannot be enforced for some reason. It also informs them that they may want to have a discussion with the custodian on whether RI can be turned on or not. Finally, data analysts and developers will find higher quality on tables with RI enabled in the database along with the narrative and data quality mechanisms implemented. This will encourage them to use these data stores with confidence.
Please sign in to leave a comment.