Answer / vennela12

DBA want to check the table structure regarding load..

In Fload case table structure should have set table and index should be UPI

In Mload case table structure should have any table and any index

What is basic teradata query language?

0 Answers  

---

Can we collect statistics on table level?

0 Answers  

---

The transaction exceeded the maximum number of rowhash locks allowed

1 Answers   Wipro,

---

Highlight the differences between Primary Key and Primary Index.

0 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

0 Answers  

---

How do you eliminate duplicates?

3 Answers  

---

What are normalization, first normal form, second normal form and third normal form?

0 Answers  

---

what is use of PI(primary index) AND SI(secondary index)

2 Answers   Wipro,

---

what is DYNAMIC SQL in TD?

1 Answers   IBM,

---

What is use of compress in terdata?Explain?

11 Answers  

---

Explain fastload in teradata?

0 Answers  

---