Why MLOAD needs Work Tables?

Answer Posted / yuvaevergreen

Adding to the above, the work tables are created in
permanent space and used by the amps. Be aware of the
estimated perm space so that mload performance would be good.

Is This Answer Correct ?    6 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are default access rights in teradata? What explicit right can be given to a user?

651


What is a node in teradata? Explain

603


How you will check the version of teradata?

588


Give a justifiable reason why Multi-load supports NUSI instead of USI.

677


Explain how spool space is used.

617






What is the use of stored procedures in teradata?

568


What exactly do you know about catching in teradata?

638


What are the different functions included in the server software?

603


what is object level locking ? where do appear this type of locking ?

3113


How many tables can you join in v2r5?

626


What are different table types used in teradata?

587


What is the basic syntax for teradata select statement?

578


How to select first n records in teradata?

611


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

559


How would you load a very large file in teradata in general? What utility would you use for it? Why?

601