Answer Posted / rkraju

yes we can load 10 millions of records into target table by
using tpump but it takes more time.y because it applies
rowhash lock on each row.,
>>generally less volume of data we go for tpump.,
>>if the table doen't have any limitations of fastload d
multiload then go for fastload.,

What are the different table types supported by teradata?

947

---

How to select first n records in teradata?

1082

---

What is bteq utility in teradata?

950

---

What is the difference between global temporary tables and volatile temporary tables?

1152

---

What is a node in teradata? Explain

980

---

How many codd's rules are satisfied by teradata database?

1095

---

Explain teradata architecture?

1068

---

What are the functions of a Parser?

1088

---

Comment whether bottleneck is an error or not.

1124

---

What are the multiload utility limitations?

1039

---

Explain some differences between mpp and smp?

1080

---

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

978

---

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

1016

---

if collect stats but it show low confidence why?

1673

---

what is object level locking ? where do appear this type of locking ?

3475

---