Answer Posted / sat!sh

MULTILOAD will creates 2 error tables, 1 work table

When MULTILOAD fails We have to unlock the Main Table, here
error tables and work tables are not locked like FLOAD

To Unlock the Main Table in Mload

RELEASE MLOAD <TABLE NAME>;

----
Hi Friends Got a Best ANS share with us :)

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

984

---

What do you mean by tpt in teradata?

1021

---

how many modules are there in telecome domain?how to explain the architecture?

2016

---

Highlight the points of differences between the database and user in Teradata.

1109

---

what is sysdba and sysdbc ? which has high priority ?

3832

---

What do you mean by teradata intellicloud?

1038

---

Highlight the limitations of TPUMP Utility.

1112

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1081

---

What is the difference between fastload and multiload? Which one is faster?

1227

---

How do you do backup and recovery in teradata?

1023

---

How does hashing happens in teradata?

1092

---

What is the command in bteq to check for session settings ?

1180

---

What are the steps involved after the disk manager passes the request?

1122

---

How to load specific no.of records using bteq, or fastload,or multiload

1748

---

List out all forms of LOCKS that are available in Teradata.

969

---