If table have access lock.In the same table write lock is
posible or not?
Answer / yuvaevergreen
yes...its possible...when access lock is present in a table, write lock can be inteded for the the same table.
Is This Answer Correct ? | 8 Yes | 0 No |
What are the design features involved in teradata?
How to relege locks in fastload and multiload? example?
Diff b/w v2r5 and v2r6 ?
Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
if a error occured in FASTLOAD is the fastload job stops?
What is basic teradata query language?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
how do you handle ET and UV errors ?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is meant by a dispatcher?
what is identity column in TD?