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  

---

IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.

2 Answers  

---

what is identity columns in TD?

2 Answers   Wipro,

---

can we load 10 millions of records into target table by using tpump?

1 Answers   HP,

---

What is dimensional modeling?

0 Answers  

---

In your project what type of issues and errors you facing in Teradata

1 Answers   iGate,

---

what is use of fload loading into set table?

2 Answers   IBM,

---

What are the components used in smp and massively parallel processing (mpp) machines?

0 Answers  

---

What are the various indexes in teradata? How to use them? Why are they preferred?

0 Answers  

---

How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  

---

What is the difference between correlated sub queries and inner queries?

4 Answers  

---

Can you fastexport a field, which is primary key by putting equality on that key?

0 Answers  

---