what is meant by Hot amp?
- 2 Answers
- 12630 Views
- IBM, Satyam, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / guest
HOT AMP is a condition when data is NOT EQUALLY DISTRIBUTED
among AMPS and all the data is present in one or few AMPs.
In that case , when user fires SELECT query ,only the
processing power of one or few AMPs among many AMPs will be
used while others AMPS will be IDLE leading to the condition
called HOT AMPs in DB.
In case of HOT AMPs , query performance is very POOR.
Teradata Developer must try to choose PI in such a way that
uniquely distributes the data among AMPs and not lead to HOT
AMPs in Teradata Server.
| Is This Answer Correct ? | 13 Yes | 0 No |
Answer / 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 |
Which is faster fastload or multiload?
i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.
Can you load multiple data files for same target table using fastload?
In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?
What tools would you use for that?
What is the difference between correlated sub queries and inner queries?
in teradata level primary in table level allows duplicates why?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
How does indexing improve query performance?
What are the components used in smp and massively parallel processing (mpp) machines?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
The transaction exceeded the maximum number of rowhash locks allowed
Teradata 
