We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

---

Difference between inner join and outer join?

0 Answers  

---

What is the process to restart the multiload if it fails?

7 Answers  

---

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,

---

What does Amp contain and what are all the operations that it performs?

0 Answers  

---

Why do Hash joins usually perform better than Merge Joins?

1 Answers  

---

What is SQL Assistence?please eample

4 Answers   IBM,

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

What are teradata utilities?

0 Answers  

---

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 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,

---

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---