What is spool space?

0 Answers  

---

How to find No. of Records present in Each AMP or a Node for a given Table through SQL?

2 Answers   IBM,

---

Highlight the points of differences between the database and user in Teradata.

0 Answers  

---

Explain how spool space is used.

0 Answers  

---

How to view every column and the columns contained in indexes in teradata?

0 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

---

In which phase of the Active Data Warehouse evolution do you use data to determine what will happen?

2 Answers   IBM, Wipro,

---

Difference between inner join and outer join?

0 Answers  

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

0 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,

---