I am using the Field Validation to test our ETL. Using this as source data:
And these rules in the DSA:
And this query to check for errors:
I get the following result:
The _L table is linking to the records in the _R table that were removed when they failed the validation step on FIRST_NAME. Also the Warning level notification is not present in the table.
As it stands the _L, _R, and _M tables as joined above are showing incorrect or at least confusing information. Am I using them as they were intended to be used, and has anyone done anything to get around this?