Thanks for the response. I am still unable to understand how do I do a insert/update/delete in one shot? Because there is 'Insert/update' and 'Delete'. How do I put these together?
I understand Enterprise, gives CDC. But I am supposed to do this in TOS itself
Yes I understand it must be done in sequence. So, the flow,
tmssqlinput --> tmap --> tmysqloutput(insertupdate)
|--> tmysqloutput (delete)
My question is tmap is outputting, both insert/update and delete at the same time. How will the table handle this simultaneously?