Interested to Buy Any Domain ? << Click Here >> for more details...
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 do you mean by ttu in teradata?
In the Primary Index, what is the score of AMPs that are actively involved?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Highlight the points of differences between the database and user in Teradata.
Explain the types of join supports by teradata?
What is a dimension table?
How does hashing happens in teradata?
What is inner join and outer join?
Explain the teradata primary index mechanics in detail with a diagram.
What is the difference between union and union all in teradata?
What do you mean by caching in teradata?
What is a node in teradata?
What is the purpose of upsert command?
What is the basic syntax for teradata select statement?
If RDBMS is halted what will you do ?
