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.

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.

Explain the new features of teradata?

0 Answers  

---

what is identity column in TD?

2 Answers   Wipro,

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

what is identity columns in TD?

2 Answers   Wipro,

---

How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  

---

What are the design features involved in teradata?

0 Answers  

---

What are the string manipulation operators and functions associated with teradata?

0 Answers  

---

what are the file sizes in your project?

2 Answers  

---

what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,

---

Why MLOAD needs Work Tables?

5 Answers   Teradata,

---

Can we load a Multi set table using MLOAD?

2 Answers  

---