Teradata table - Reading and Writing in same job
Posted: Mon Jan 23, 2012 4:28 pm
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
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