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


Please Help Members By Posting Answers For Below Questions

What is a clique?

779


If RDBMS is halted what will you do ?

1904


What is basic teradata query language?

831


What tools would you use for that?

797


How will you solve the problem that occurs during update?

790


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?

1811


Explain the teradata primary index mechanics in detail with a diagram.

745


What are default access rights in teradata?

838


What is smp and mpp platforms?

712


Highlight the advantages of PPI(Partition Primary Index).

782


why use references rather than pointers in the public api, particularly for arguments which are modified?

751


What is meant by a Clique?

799


What is the basic syntax for teradata select statement?

765


Explain teradata utilities. What is multiload, fast load, tpump?

760


What is the purpose of joins in teradata?

780