In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

0 Answers  

---

what is DYNAMIC SQL in TD?

1 Answers   IBM,

---

What are different table types used in teradata?

0 Answers  

---

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers   Cap Gemini,

---

Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....

3 Answers  

---

What can be achieved by using the teradata rdbms?

0 Answers  

---

What is the purpose of indexes?

0 Answers  

---

can i call router is a passive transformation

2 Answers  

---

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

---

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

---