Insert & Ins-Update operations in Same DB table in a one

[Ashish]

Hi DS Gurus,

I would like your suggestion in designing a parallel job.

Job Design is

Input of transformer is Seq. file and output is 2 links which again input to the Same database table.

1st link containing only New-Inserts records for Table X

2nd link containing Insert-Updates records for Table X

Is there any problem when both links parallely hit the same database table?

Thanks
Ashish

[ArndW]

Assuming you are not inserting and updating the same record at the same time or in the same run (in which case you'd need to commit on each row) you shouldn't have issues. While your approach is more efficient, you can also have the DB stage decide which operation to perform.