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.
Insert,update,insert/update on same table in same job
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 5
- Joined: Sun Dec 30, 2012 11:56 pm
Re: Insert,update,insert/update on same table in same job
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
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
manumace
-
- Premium Member
- Posts: 353
- Joined: Mon Jan 17, 2011 5:03 am
- Location: Mumbai, India
Re: Insert,update,insert/update on same table in same job
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
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
mgplk
-
- Premium Member
- Posts: 278
- Joined: Wed Oct 03, 2007 8:45 am