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

What are the frequently used data types in teradata?

1004

---

What is the purpose of upsert command?

1078

---

What are the components provided on node?

985

---

Highlight the limitations of TPUMP Utility.

1048

---

What are the primary characteristics of the Teradata.

1058

---

What are the multiload utility limitations?

1003

---

What is the purpose of joins in teradata and what are the available join types?

1001

---

Mention a few of the ETL tools that come under Teradata.

1014

---

What are the joins in teradata and how many types of joins are there in teradata?

960

---

what is sysdba and sysdbc ? which has high priority ?

3759

---

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

2418

---

What is the opening step in basic teradata query script?

977

---

What do you mean by parsing?

1057

---

What are the functions performed by bynet?

980

---

Explain the teradata primary index mechanics in detail with a diagram.

910

---