Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by Hot amp?
- 2 Answers
- 13686 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 |
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
What is FILLER command in Teradata?
How to find No. of Records present in Each AMP or a Node for a given Table through SQL?
What are types of partition primary index (ppi) in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
what are the default access rights in the teradata?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
What is the meaning of Caching in Teradata?
What is a three-tier data warehouse?
Give some points about Teradata Viewpoint ?
Teradata 
