Teradata table - Reading and Writing in same job

[rroy2]

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

[qt_ky]

I would break it into 2 separate jobs to be on the safe side, but I don't know anything about Teradata...

[jericho]

Try reading from a view to update/insert into the target table.