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
What is the purpose of joins in teradata?
Explain how spool space is used.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What are the string manipulation operators and functions associated with teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What are the functions performed by bynet?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What is the difference between teradata and oracle?
List the logical and conditional operators that are used with teradata along with their meanings?
Why does varchar occupy 2 extra bytes?
What is the use of fallback?
In Teradata, how do we Generate Sequence?
What is the use of having index on table?
List out teradata data types?