Answer / yuvaevergreen

Loading: Automatically happens during utility running.
Extracting: select * can be used in a bteq and the rows can
be exported.

Answer / vinay sir(datawarehousing tech

Yuva answer is right and I am adding little more to that.

The error table structure is different from one Utility
to Other.After retrieval we need to understand and analyse
the below error table stuctures.

Syntax: Select * from Databasename.Errortablename

Eg: In Fast Load Error table Fields:
a.Errorcode
b.Error Field
c.DataParcel

In MLOAD the error table fields are:

a.IMPORTSEQ
b.DMLSEQ
c.SMTSEQ
d.SOURCESEQ
e.APPLYSEQ
f.Errorcode
g.ErrorField
h.Uniqueness
i.DataParcel etc.....

Answer / tdguy

to see, just use sel * from, in sql assistant.

write lock is compatiable with which type of lock?

6 Answers   Infosys,

---

any one pls tell me what are the table names in banking project?

2 Answers  

---

In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??

3 Answers   CTS, Lexicon,

---

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 ?

0 Answers  

---

What are the differences between TerdataV2R5 and V12 Versions please??

3 Answers  

---

How does hashing happens in teradata?

0 Answers  

---

Increasing no of amps will increase performance. Is this true?

5 Answers   Infosys,

---

Explain and compare pros and cons of start schemas?

0 Answers  

---

what is the difference between primary index and secondary index?.

2 Answers   IBM,

---

What is real time and near real time data warehousing?

0 Answers  

---

List out some of the primary characteristics of teradata.

0 Answers  

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

0 Answers   HP,

---