DSXchange

Hi,

Another issue.

Job design is as follows

HashFile --> Transformer --- > INSERT/UPDATE TO TABLE
|
|
Lookup Table

Lookup table is the same table that i am inserting and updating to..
Will this work ... In the log i can see oracle deadlock messages
can it be due to simulatneous read/write by this job

Thanks in advance

Hi,
You already ahve the answer to the problem.
How are having the same link table for reading and simultaneous updates?


Ketfos

ketfos wrote:Hi,
You already ahve the answer to the problem.
How are having the same link table for reading and simultaneous updates?


Ketfos

But evenif I do that the record will first do a lookup and then go for the insert/update right. Am I missing out something..

I thought of two ways

(*) Having the update records to be in a sequential file and then do the update operation afterwards
(*) cHAGNE THE ARRAY SIZE AND THE ROW TRANSACTION TO 1 IN THE ORACLE STAGE.

Will this solve the probelm.

Thanks in advance