Answer / gowthami

The data can be access in teradata in 3ways..
1.Full table scan
2.Primary index
3.secondary index
PRIMARY INDEX:This one is Mandatory index.Teradata
distribute data across all amps.so for distribution of data
P.I need.
accessing and retrieval is possible through primary
index.which contains..1)UNIQUE PRIMARY INDEX 3)NON UNIQUE
PRIMARY INDEX 3)PARTITIONED PRIMARY INDEX 4)NO PRIMARY
INDEX(from teradta13)
SECONDARY INDEX:only retrival possibele through secondary
index.Means it doesnot distribute the data.
Using scenario::-There is a primary index on the table.But
we are using other than primary index colums in the where
clause as part of frequently retrival data.In this situation
system does full table scan,To avoid this take SI on the table.

Friends if any one have the better ans plz add.

Answer / tdguy

PI - mandatory and very important in TD. Useful in
distribution and retrieval. Performance of TD highly
depends on PI.
SI - Optional and provides alternate path to data. When
choosen appropriately, this improves the performance of
queries.

What is the purpose of joins in teradata?

0 Answers  

---

Pls any body reply for this question. Which circumstance does the optimizing choose a product join? Thanks for advance

6 Answers   Cap Gemini,

---

What is the basic syntax for teradata select statement?

0 Answers  

---

I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.

13 Answers  

---

Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M

6 Answers   JPMorgan Chase,

---

What is a node in teradata?

0 Answers  

---

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

---

how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,

---

Can you load multiple data files for same target table using fastload?

1 Answers  

---

Explain Teradata performance tuning and optimization?

0 Answers  

---

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

1 Answers   IBM,

---

What is meant by a node?

0 Answers  

---