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
Highlight a few of the important components of Teradata?
Describe primary index in teradata?
What are the components used in smp and massively parallel processing (mpp) machines?
What are the frequently used data types in teradata?
How do you set the session mode parameters in bteq?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different functions performed in development phase?
What are the newly developed features of Teradata?
What are tpump utility limitations?
What are the different methods ot loading a dimension table? A fact table etc?
Highlight the need for Performance Tuning.
Explain vproc in teradata?
What are different table types used in teradata?
What is meant by a Highest Cost Plan?
What are some primary characteristics of teradata?