How to relege locks in fastload and multiload? example?
Answer Posted / siva
In mload lock
in accquisition phase Release mload databasename.tablename
in application phase Release mload tablename .in apply
In fload between begin loading and end loading there not
write any code and run the script.locks will be relesed
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
how do you manage the production space. what are the proactive methods you can take ?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
What do you mean by tpt in teradata?
Explain teradata architecture in detail with a diagram.
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?
While creating table my dba has fallback or no fallback in his ddl. What is that?
What is the meaning of Caching in Teradata?
What interface is used to connect to windows based applications?
What are differences between teradata and ansi session modes in teradata?
Why managing the data is important?
What are the different functions included in the server software?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain fallback in teradata?
What is the use of virtual processor connectivity in teradata?
In BTEQ, how are the session-mode parameters being set?