Anyone please tell, why DS parallel job is keep on running when I select UPSERT method. If I select Load only, it runs fine. Here I am giving update with condition two fields out of 26 of incoming records should match with existing records and also enddate should be greater than system date.
And then insert all incoming record into the Target table. These record datas are coming from CDC with change code = "Edit"/3.
I tried the same logic with small other example, the same case happened.
Appreciate, anyone's information for the problem.
thanks, IOWAJAX
UPSERT Deadlock
Moderators: chulett, rschirm, roy
Hi,
Iam still not clear what you are trying to convey but I will tell you what we have done maybe it will be of help to you.
For Insert we have used Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the insert script.
For Update we have used Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the update script.
HTH
--Rich
A little bit of ink is powerful than the strongest memory
--Confucius
Iam still not clear what you are trying to convey but I will tell you what we have done maybe it will be of help to you.
For Insert we have used Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the insert script.
For Update we have used Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the update script.
HTH
--Rich
A little bit of ink is powerful than the strongest memory
--Confucius
Load only and UPSERT are vastly different actions in the database. UPSERT involves DML, where Load uses sqlldr. So, in a nutshell, you're comparing DML loading versus sqlldr, and probably sqlldr DIRECT path.
Kenneth Bland
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
Rank: Sempai
Belt: First degree black
Fight name: Captain Hook
Signature knockout: right upper cut followed by left hook
Signature submission: Crucifix combined with leg triangle
From CDC output the records to a transformer. When the change code is "3" the record should be both updated (probably logical delete or whatever update needs to be done for the existing records) and freshly insert again with new values. So, in the transformer send the insert records and update records into 2 different link outputs.
After that you can do as Rich mentioned in his reply.
For Insert use Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the insert script.
For Update use Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the update script.
Srikanth
After that you can do as Rich mentioned in his reply.
For Insert use Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the insert script.
For Update use Write Method as Upsert and Upsert Mode as User Defined Update Only and gave the update script.
Srikanth