Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by Hot amp?
- 2 Answers
- 13797 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 |
What is a node in teradata?
what is meant by Hot amp?
What are the different softwares used with their functions in teradata?
suppose one Cylinder split data blocks are moved from where?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
During the Display time, how is the sequence generated by Teradata?
How do you do backup and recovery in teradata?
What's the difference between timestamp (0) and timestamp (6)?
Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
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?
What is dimensional modeling?
Teradata 
