Answer Posted / guru

If Mload failed in the Acquisition phase just rerun the
job.If Mload failed in Application Phase:
a) Try to drop error tables, work tables, log tables,
release Mload if required n submit the job
from .Begin Import onwards.
b) if ur table is fallback protected u need to make sure un
fallback and use RELEASE MLOAD IN APPLY sql.
Then resubmit the job.

Guru,
Advanced Teradata Certified Professional

How many types of joins are there in teradata?

978

---

Highlight the need for Performance Tuning.

1111

---

What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?

1110

---

How would you load a very large file in teradata in general?

1034

---

What are the multiload utility limitations?

1064

---

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

980

---

if collect stats but it show low confidence why?

1691

---

Why does varchar occupy 2 extra bytes?

1198

---

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

2016

---

What are the different design perspectives used in teradata?

983

---

What is the difference between teradata and basic rdbms?

1030

---

Can you fastexport a field, which is primary key by putting equality on that key?

1180

---

What are teradata utilities?

1113

---

How many tables can you join in v2r5?

1074

---

What are the components provided on node?

1048

---