What is the difference between union and union all in teradata?

0 Answers  

---

id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???

6 Answers   Cap Gemini,

---

What are the scenarios in which full table scans occurs?

0 Answers  

---

How is the teradata different from oracle?

0 Answers  

---

How can bottlenecks be identified?

0 Answers  

---

---

What are the available primary index types in teradata.

0 Answers  

---

what is use of PI(primary index) AND SI(secondary index)

2 Answers   Wipro,

---

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

0 Answers  

---

what are the default access rights in the teradata?

1 Answers  

---

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

---

in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?

2 Answers   HCL,

---

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

0 Answers  

---