Interested to Buy Any Domain ? << Click Here >> for more details...
How to relege locks in fastload and multiload? example?
- 4 Answers
- 23009 Views
- IBM, I also Faced
- E-Mail Answers
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
What are the enhanced features in teradata v2r5 and v2r6?
Is multi insert ansi standard?
Explain fallback in teradata?
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is the difference between global temporary tables and volatile temporary tables?
What are the joins in teradata?
What is the maximum number of dml can be coded in a multiload script?
How many sessions of MAX is PE capable of handling at a particular time?
How do you see a ddl for an existing table?
What are some primary characteristics of teradata?
Explain teradata architecture?
What is the multi-insert?
What are the various reporting tools in the market?
Differentiate primary key and partition key?
