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 :)

In the Primary Index, what is the score of AMPs that are actively involved?

1125

---

Name the five phases that come under MultiLoad Utility.

1028

---

What is spool space? Why do you get spool space errors?

1079

---

What happens when a node suffers a downfall?

1187

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1257

---

Difference between star and snowflake schemas?

1240

---

What are the newly developed features of Teradata?

1081

---

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

1181

---

What are the commands to make a new table, change a table and remove a table in teradata?

1182

---

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

1081

---

Explain teradata architecture?

1147

---

What is multi insert?

1108

---

What is the use of teradata system software?

1087

---

What is meant by a Parsing Engine?

1234

---

There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

1149

---