Answer / Vikas Dubey

In Teradata's Set tables, duplicate rows are prevented using the Deduplication feature. This is done by storing only one copy of each unique row and maintaining pointers to the original row. When retrieving data, Teradata returns only the original row, not the pointers.

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer

2 Answers   IBM,

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

How to load specific no.of records using bteq, or fastload,or multiload

1 Answers   Infosys,

---

What is meant by a Least Cost Plan?

1 Answers  

---

why should we go Teradata over Oracle,what is the main differences?

4 Answers   TCS,

---

What is the maximum number of dml can be coded in a multiload script?

1 Answers  

---

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me

8 Answers   Satyam,

---

How you will check the version of teradata?

1 Answers  

---

Does SDLC changes when you use Teradata instead of Oracle?

2 Answers  

---

what is referential constraints?how do you implement RI in teradata?

2 Answers   Wipro,

---

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

---