How do you design aggregate tables using teradata?

1 Answers  

---

In BTEQ, how are the session-mode parameters being set?

0 Answers  

---

What is bteq utility in teradata?

0 Answers  

---

Explain the term 'primary key' related to relational database management system?

0 Answers  

---

Difference between client character set and server character set? What is the use of these two?default character set in teradata?

1 Answers   TCS,

---

How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .

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,

---

Which Teradata concept allows more than one model generation?

1 Answers   TCS,

---

Difference between star and snowflake schemas?

0 Answers  

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

0 Answers  

---

In Teradata, how do we Generate Sequence?

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,

---