Answer Posted / 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.....
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is database exceptions in teradata?
What are the joins in teradata?
What interface is used to connect to windows based applications?
Explain the meaning of Amp?
What are the components provided on node?
What is the use of stored procedures in teradata?
Explain Teradata performance tuning and optimization?
Is multi insert ansi standard?
What are teradata utilities?
Explain the teradata primary index mechanics in detail with a diagram.
What are the components used in smp and massively parallel processing (mpp) machines?
What is a sparse index?
What is bteq script in teradata?
What is partitioned primary index (ppi)?
Differentiate primary key and partition key?
