Hi Masters ,
I have one scenario jdbc to file here in sender jdbc i have one control table and one data table .. in control table there is one field name counter .. now in mapping if counter is less than 3 then it should throw error and update status field of source as E (error) and if it is greater or equals to 3 then it should process the message .
Is it possible to throw error ... or how to throw error ........ as i know with the help of BPM we can throw error ..but here in this case we are not using BPM.
Thanks in advance,
If the counter value is less then 3 then ur mapping completly fails,If yes then just create Alert catagory and create Alert rule.Using this u can send an Email or trigger an alert to the end user.
Creating Alert Check this links,Its simple to create an Alert catagory and Alert rule.
Reward points if Helpful