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?
Thanks,
Mark
Best answer by JTreadwell
Hi Mark,
Yes, that looks okay to me.
The validation operators specifiy which data is VALID. So in your example: "Not in list ('Bat', 'Super')" means that Batman and Superman are VALID entries, therefore will not be flagged by the validation rule. Both the Error AND the Warning are flagging Ironman and because you're using an Inner join, you are only seeing one of the messages.
Try swapping the logic on your validation rules and see if it gives you the desired results.
You can also see the results by viewing the error/warning from the reports menu in TimeXtender.
The validation operators specifiy which data is VALID. So in your example: "Not in list ('Bat', 'Super')" means that Batman and Superman are VALID entries, therefore will not be flagged by the validation rule. Both the Error AND the Warning are flagging Ironman and because you're using an Inner join, you are only seeing one of the messages.
Try swapping the logic on your validation rules and see if it gives you the desired results.
You can also see the results by viewing the error/warning from the reports menu in TimeXtender.
We use 3 different kinds of cookies. You can choose which cookies you want to accept. We need basic cookies to make this site work, therefore these are the minimum you can select. Learn more about our cookies.
