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

What are the components used in smp and massively parallel processing (mpp) machines?

803


What is the use of fallback?

741


Which is faster fastload or multiload?

795


How to Extract data from multiple legacy systems?

788


How do you see a ddl for an existing table?

753


How is the teradata different from oracle?

801


What is the opening step in basic teradata query script?

768


Define views in teradata with syntax.

810


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

794


What is the use of virtual processor connectivity in teradata?

765


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

882


What is a level of granularity of a fact table?

811


What do you mean by teradata intelliflex?

823


Can you fastexport a field, which is primary key by putting equality on that key?

941


What happens in a conflict? How do you handle that?

819