Insert,update,insert/update on same table in same job

[sriram_bcl]

I have one job where in Server edition doing four operations on same table in same job i.e insert,update,insert/update,update with four different links with different filter conditions.

To implement same logic in PX, I am not able to do. I am getting unique constraint violation error. Please suggest is there any way to resolve this.

[manumace]

Hi,

If the server job is working fine and Parallel is throwing error, then the issue could be "an update record is trying in insert mode". Can you please verify the data with a peak or trace mode.

Hope you have marked the Key column properly.

Regards,
Manu

[chandra.shekhar@tcs.com]

I think it is a better practice to do all inserts in 1 job and updates(or upserts) in other job to avoid locking at the table.

[chulett]

I'm curious, does the Server job use four links to a single target?

[123gopal]

1.in ds8.5 separately SCD Stage is there otherwise can be use Slowly changing dimension(SCD) Concept types
SCD1-Insert new records and replace the orginal records
SCD2-insert new records and update the existing records and we can maintain the old records also
SCD3-insert new records and no trace of old records

[sjfearnside]

It sounds like the parallel job is trying to perform concurrent updates to the table resulting in conflicts. Try setting the DB stage performing the changes to the table to sequential mode and try the job again to see if that resolves the issue.