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
Explain the most common data types used in teradata?
What is meant by a Virtual Disk?
What's the difference between timestamp (0) and timestamp (6)?
What are the various etl tools in the market?
What is database exceptions in teradata?
Syntax for case when statement?
How is MLOAD Teradata Server restarted after execution?
What is the use of fallback?
What is the maximum number of dml can be coded in a multiload script?
Name the five phases that come under MultiLoad Utility.
what is sysdba and sysdbc ? which has high priority ?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
What is the syntax for case when statement?
Describe primary index in teradata?
How to identify ppi columns?