Answer Posted / sat!sh

The above ans is only when the MLOAD failed in acquisation phase

To release lock in application phase failure in MLOAD

RELEASE MLOAD <Table Name> .IN APPLY;

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

What is the function of parser component in teradata?

1036

---

What is the use of stored procedures in teradata?

942

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1113

---

What is meant by Teradata Gateway?

1003

---

What are the functions involved in shared information architecture?

1016

---

What happens in a conflict? How do you handle that?

987

---

What are teradata utilities?

1032

---

What is real time and near real time data warehousing?

1063

---

What are the various etl tools in the market?

1016

---

Can we collect statistics on table level?

987

---

In general, how do you optimze any sql in teradata?

974

---

Highlight the advantages of PPI(Partition Primary Index).

1004

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1089

---

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

929

---

Name the five phases that come under MultiLoad Utility.

928

---