How to relege locks in fastload and multiload? example?
Answer Posted / tdguy
mload: release mload dbname.tablename or release mload
dbname.tablename in apply.
fload: script with only begin loading and end loading
commands will release the locks.
Is This Answer Correct ? | 3 Yes | 0 No |
Post New Answer View All Answers
What is a clique?
If RDBMS is halted what will you do ?
What is basic teradata query language?
What tools would you use for that?
How will you solve the problem that occurs during update?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Explain the teradata primary index mechanics in detail with a diagram.
What are default access rights in teradata?
What is smp and mpp platforms?
Highlight the advantages of PPI(Partition Primary Index).
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is meant by a Clique?
What is the basic syntax for teradata select statement?
Explain teradata utilities. What is multiload, fast load, tpump?
What is the purpose of joins in teradata?