_L and _M Table Behavior

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?






Please sign in to leave a comment.