Just wanted to ask for those who have quite a lot of experience, I am wondering where is it best to put validation on an excel input file. Is it during the dispatcher process or the performer?
How do you validate each column that is required to have a value? If null we throw new BusinessRuleException(“Incomplete Details.”)
in should be in the dispatcher process, so once the data is validated, it will just upload all the data that the perfomer will process, based on that our performer process will just executed the validated data and will process all without need any validation (only validations about applications but not about data)