I’d like to run a number of validations over the imported data and be able to ‘report’ on any exceptions.
Ideally I would like to append each record that fails validation to a separate table, populating a column that indicates which validation test it failed.
These would then be reviewed by the data owners.
How would I achieve this in EasyMorph?
Apologies if this is a noob question, I’m new to EasyMorph and haven’t yet found an answer.