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

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?

1191

---

how do you manage the production space. what are the proactive methods you can take ?

1938

---

Did you write stored procedures in teradata?

1126

---

Why managing the data is important?

1011

---

What is spool space?

1149

---

How to load specific no.of records using bteq, or fastload,or multiload

1740

---

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

941

---

What is a node in teradata?

989

---

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

1071

---

How to identify ppi columns?

1173

---

Explain teradata utilities?

1032

---

What are the advantages of teradata?

1006

---

Explain fastload in teradata?

1094

---

Can we collect statistics on multiple columns?

1055

---

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3369

---