Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by Hot amp?
- 2 Answers
- 13806 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 |
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Explain the new features of teradata?
Aborted in Phase 1 data Acquistion Incomplete in fastload?
How to relege locks in fastload and multiload? example?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
What is a dimension table?
Explain the term 'columns' related to relational database management system?
What is the purpose of joins in teradata?
how to load or extract the error table data ?
How do you Generate Sequence in Teradata?
What is the use of fallback?
Explain the meaning of Amp?
Teradata 
