Parallel job process

[Hema.k]

Hi,

I have developed a parallel job which has two different design,one is for insertion of records and another one to Update the records.
Both Insertion & Updation is on same table and the job is running fine.

Can anyone explain how the job is processed while running i.e. which one will happen first insertion or updation?

Thanks in advance.

Regards,
Hema K

[soumya5891]

Are you using Upsert method or you are doing insert and update seperately in different stages

[Hema.k]

I have a single job and the design of the job is as follows:

Odbc---->Transformer---->Netezza (Insertion)
Row Generator ------> Odbc (Updation)


Regards,
Hema K

[jwiles]

The two streams are running independently, nearly as if you had two separate jobs submitted at the same time. Therefore, you will see updates and inserts happening at the same time.

Regards,