AnsweredAssumed Answered

Insert vs Update process

Question asked by AdamTopper on Sep 21, 2016
Latest reply on Sep 22, 2016 by gilta03

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.  

Outcomes