How to relege locks in fastload and multiload? example?
Answer Posted / yuvaevergreen
For mload,
release mload in apply can be used to forcefully remove the lock from the target table.
For fload,
Locks on target table will not be released until end loading statement completes. I hope fload should be run only with begin and end loading statements. Please add, if you find more....
Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
How to identify ppi columns?
What are the various indexes in teradata? Why are they preferred?
What is smp and mpp platforms?
Why managing the data is important?
Explain amp in teradata?
How is the teradata different from oracle?
Explain the term 'foreign key' related to relational database management system?
What is spool space? Why do you get spool space errors?
How many tables can you join in v2r5?
What are the different table types that are supported by teradata?
What is TPD?
Comment whether bottleneck is an error or not.
Explain the advantages of partitioned primary index in a query?
How do you determine the number of sessions?
What is the difference between fastload and multiload? Which one is faster?