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,

---

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 teradata and why it is used?

0 Answers  

---

What is spool space? Why do you get spool space errors?

0 Answers  

---

Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,

---

I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  

---

what are the default access rights in the teradata?

1 Answers  

---

What is the use of upsert command in teradata?

1 Answers  

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

0 Answers  

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

0 Answers  

---

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

7 Answers  

---