what is meant by Hot amp?

Answer Posted / tdguy

highly non unique PI values, more number of null values can
create a hot amp condition., which means one or more amps
will be holding more rows than other amps. Distribution
occurs unevenly. This can cause out of spool space error.

Is This Answer Correct ?    5 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain vproc in teradata?

566


What is teradata and why it is used?

593


What is a node in teradata?

587


What is spool space? Why do you get spool space errors? How do trouble-shoot them?

540


What are the uses of client software involved in teradata?

538






What are the design features involved in teradata?

549


What is the difference between fastload and multiload? Which one is faster?

601


How to Extract data from multiple legacy systems?

576


Is multi insert ansi standard?

1753


What are the various indexes in teradata?

571


If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

1900


How many codd's rules are satisfied by teradata database?

665


How you will check the version of teradata?

590


What do you mean by fastexport in teradata?

561


How do you create tables? Exact syntax, and create profiles, users in teradata?

562