Answer Posted / kumar

Modification to Answer#3 placed above.
Mload fails in application phase: Then e can not access the
table.

1. The solution is we need to restart the mload job or drop
the original table and worktable and logtable and error
tables.

2. If we remove worktables, errortables and logtables then
we can restart the mload job. If we try to restart then it
gives the error messages saying worktable is missing for
the table. Even release mload also doesn't work.

2. If we don't remove: Then if we restart mload job, then
it will be fine and start from the checkpoint, of the last
block that have updated to disk.

Define views in teradata with general syntax.

1004

---

What is the function of parser component in teradata?

1054

---

What are default access rights in teradata? What explicit right can be given to a user?

1077

---

Why managing the data is important?

978

---

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3563

---

any one answer me how they can analyzing the project using data ware housing?

2429

---

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

2157

---

Where is teradata rdbms used?

1056

---

Explain parsing engine in teradata?

1044

---

Discuss the advantages of using partitioned primary index in a query?

922

---

Explain the parallel data extension in teradata?

1049

---

What is the purpose of using case expression in teradata?

974

---

What is the maximum number of dml can be coded in a multiload script?

1072

---

What is bteq script in teradata?

1104

---

What is meant by a Channel Driver?

1171

---