What is bteq utility 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,

---

How do you define Teradata?

0 Answers  

---

I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.

4 Answers   Cap Gemini,

---

What is the difference between global temporary tables and volatile temporary tables?

0 Answers  

---

---

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

1 Answers   CTS, Deloitte,

---

Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?

0 Answers  

---

Why teradata is used?

0 Answers  

---

Can u load same data into multiple tables using multiload? How will be the loading process? Whether it will be serially or parallely?

2 Answers   IBM,

---

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

---

What is the use of virtual processor connectivity in teradata?

0 Answers  

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---