Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

0 Answers   IBM,

---

Why MLOAD needs Work Tables?

5 Answers   Teradata,

---

How to select first n records in teradata?

0 Answers  

---

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

0 Answers  

---

What is database exceptions 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,

---

What is teradata and why it is used?

0 Answers  

---

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

0 Answers  

---

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  

---

if collect stats but it show low confidence why?

0 Answers   IBM,

---

What are the advantages of teradata?

0 Answers  

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

---