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 are the functions of a teradata dba?
How can you track login parameters of users in teradata?
What is bteq script in teradata?
How many types of joins are there in teradata?
What is the difference between fastload and multiload? Which one is faster?
what is object level locking ? where do appear this type of locking ?
What is the difference between teradata and oracle?
How do you set the session mode parameters in bteq?
What are the functions of a Parser?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the different design perspectives used in teradata?
What are the available primary index types?
Why managing the data is important?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Describe primary index in teradata. And what are the available primary index types?