in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

---

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,

---

Why do you get spool space errors? How do trouble-shoot them?

0 Answers  

---

What is upsert statement in teradata?

0 Answers  

---

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

4 Answers   Mphasis,

---

---

what is meant by Hot amp?

2 Answers   IBM, Satyam,

---

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

7 Answers  

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

What are the updated features of teradata?

0 Answers  

---

What are the enhanced features in teradata v2r5 and v2r6?

0 Answers  

---

What is teradata? Also, list out some of the primary characteristics of teradata.

0 Answers  

---

Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  

---