How do you design aggregate tables using teradata?

1 Answers  

---

How to run the Teradata jobs in unix environment ???

4 Answers   IBM,

---

What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,

---

What is partitioned primary index (ppi)?

0 Answers  

---

What is real time and near real time data warehousing?

0 Answers  

---

What is inner join and outer join?

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  

---

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,

---

what are the uses of fact table and dimension table in banking project?

0 Answers   TCS,

---

Can we load a Multi set table using MLOAD?

2 Answers  

---

Explain and compare pros and cons of start schemas?

0 Answers  

---

What are the joins in teradata?

0 Answers  

---