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

How do you verify a complicated sql?

616


Give the sizes of SMALLINT, BYTEINT and INTEGER.

655


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

1272


What is the purpose of joins in teradata and what are the available join types?

537


What is the meaning of Caching in Teradata?

684






Explain the types of join supports by teradata?

576


Explain how spool space is used.

608


What are the enhanced features in teradata v2r5 and v2r6?

680


What is primary index and secondary index?

561


What is teradata? Also, list out some of the primary characteristics of teradata.

571


My table got locked during mload due to a failed job. What do I do to perform other operations on it?

672


During the Display time, how is the sequence generated by Teradata?

610


What are the newly developed features of Teradata?

564


What interface is used to connect to windows based applications?

577


Difference between star and snowflake schemas?

596