Interested to Buy Any Domain ? << Click Here >> for more details...
what is meant by Hot amp?
- 2 Answers
- 13914 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 |
can we join volatile table with general table an global temporary table with general table ?
What is the basic syntax for teradata select statement?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
How to Extract data from multiple legacy systems?
What are the different functions performed in development phase?
What is Difference b/w PI & PPI?how to implement PPI?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
What are some commonly used bteq scripts?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
What are the different table types that are supported by teradata?
Teradata 
