How do you set the session mode parameters in bteq?

0 Answers  

---

What is the Maximum number of volatile tables that can be created?

4 Answers   Mphasis,

---

What is primary index and secondary index?

0 Answers  

---

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

0 Answers  

---

what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,

---

---

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 is the syntax for case when statement?

0 Answers  

---

If RDBMS is halted what will you do ?

0 Answers   Teradata,

---

In Teradata, how do we Generate Sequence?

0 Answers  

---

TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,

---

What are the joins in teradata and how many types of joins are there in teradata?

0 Answers  

---

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers   IBM,

---