Missing Foreign Keys (Data Quality Rule)
The following is one of the default Data Quality Rules.
For more information about Data Quality Rules, check:
- Understand Data Quality rules overview
- Take care of entries from the Data Quality rules log
- Reduce the volume of the Data Quality rules log
Missing Foreign Keys
This Data Quality rule checks if the Foreign Key Term value exists in the Model Object in relation to.
If the Data Quality rule is violated, the row is logged to the XXX_DataQualityError table rather than in the usual target table with the following error description:
Missing foreign key value for relation to \"{relatedResultTargetObject.ModelObject.Name}\"
Example:
