Answer / krishna

1 )Primary index
a)UPI
b)NUPI
2) Secondary index
a)USI
b)NUSI
3)Partition primary index
a)Range Partition
b)Case partition
4) Hash index
5)Jion index

Discuss the advantages of using partitioned primary index in a query?

0 Answers  

---

What is a common data source for the central enterprise data warehouse?

1 Answers   Wipro,

---

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

---

Explain the teradata primary index mechanics in detail with a diagram.

0 Answers  

---

Hi Frnds this que is recently asked at IBM there are two rows like aa6588fhfhf,gru282vbvv. Question is howcan we retrive the first number from two rows. Can any one help thanks in advance

5 Answers   IBM,

---

---

Differentiate database data and data warehouse data?

0 Answers  

---

1. generally how many node system will be used by the client. 2. while running mload if the job is aborted/failed at any phase what we have to look after to run the job successfully? 3.i wanted to know how to write the fastload script for table creation as well as table loading in a single script?

3 Answers  

---

What is the multi-insert?

0 Answers  

---

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

0 Answers  

---

What's the difference between timestamp (0) and timestamp (6)?

0 Answers  

---

Why teradata is used?

0 Answers  

---

Explain fastload in teradata?

0 Answers  

---