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 the string manipulation operators and functions associated with teradata?

643


What are types of partition primary index (ppi) in teradata?

592


What is multi insert?

630


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1965


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

580






Difference between inner join and outer join?

587


What are the main components of teradata system?

585


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

684


What is the use of having index on table?

586


Why teradata is used?

582


What are differences between teradata and ansi session modes in teradata?

632


Differentiate database data and data warehouse data?

590


List out all forms of LOCKS that are available in Teradata.

560


What are the different methods ot loading a dimension table? A fact table etc?

578


Explain the term 'primary key' related to relational database management system?

607