tpump - read/write to table in same job
Posted: Sat Jan 29, 2011 1:55 am
Hi,
Browsing through a project I came through jobs, which perform SCD on dimension tables.
These jobs use tpump to read/insert/update the table.
All these jobs are working fine. I thought designing jobs in such scenario would result in deadlock.
Will deadlock situation not occur for row level locks? I mean does teradata database wait until certain time for the lock to be released?
Thanks
Browsing through a project I came through jobs, which perform SCD on dimension tables.
These jobs use tpump to read/insert/update the table.
All these jobs are working fine. I thought designing jobs in such scenario would result in deadlock.
Will deadlock situation not occur for row level locks? I mean does teradata database wait until certain time for the lock to be released?
Thanks