What is the logic that TDM follows while determining whether it should run an insert or an update? When I create synthetic data and then run other jobs that update it, I get errors:
It seems that it is trying to run the insert again before determining that the update is the proper script.
This is in an AS400 system (in case the green screen did not give it away). Inserts take the normal couple moments one would expect but the updates are taking appproximately 8 hours per 1000 records.