Hello everyone, I have a situation where I’m loading around 40 tables and all I’m doing is casting the fields from varchar to their corresponding data types and adding a couple of timestamp columns. The design right now is - a single transformation job has about 40 different mappings(or subjob?), all running in parallel
How do I send out notifications(email) for errors from these?
Is there a better way to do this? Like use a control table and iterate through them to dynamically get the source and target tables and avoid having 40 different subjobs?
Please provide your suggestions.
Thanks In advance