Hi,
I have a parallel job on 8.5 using Teradata connector stages where I have to read the batch table, and then update the same batch table. The flow is like
TD (Read batch table)------>Transformer --------> TD (update same Batch table)
Will there be any risk with such design? like table getting locked as its being read/updated in same job.
Is there a way we can avoid it without breaking it into 2 separate jobs
Thanks
Teradata table - Reading and Writing in same job
Moderators: chulett, rschirm, roy
Re: Teradata table - Reading and Writing in same job
Try reading from a view to update/insert into the target table.