Answer / yuvaevergreen

Distribution of data in TD depends on primary index. SI is not involved in distribution of data. PI is mandatory whereas SI is optional. SI, if not chosen properly, is just an overhead.

Answer / tdguy

PI plays a very important role in teradata. It is used in
data distribution. Very important for joins. SI provides
alternate path for data access.

Give some points about Teradata Viewpoint ?

3 Answers   Teradata,

---

Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table

6 Answers   IBM,

---

What is basic teradata query language?

0 Answers  

---

What are the uses of bynets in multi-node systems?

0 Answers  

---

How is the teradata different from oracle?

0 Answers  

---

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,

---

A Query was run fine earlier. It is not running properly now. what are proactive steps you can take as a dba ?

1 Answers  

---

Aborted in Phase 1 data Acquistion Incomplete in fastload?

2 Answers  

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

0 Answers  

---

IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance

2 Answers   Cap Gemini, IBM, Infosys,

---

Explain some differences between mpp and smp?

0 Answers  

---

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

---