how to load or extract the error table data ?
Answers were Sorted based on User's Feedback
Answer / yuvaevergreen
Loading: Automatically happens during utility running.
Extracting: select * can be used in a bteq and the rows can
be exported.
Is This Answer Correct ? | 3 Yes | 0 No |
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.....
Is This Answer Correct ? | 1 Yes | 0 No |
Explain Teradata performance tuning and optimization?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
How many codd's rules are satisfied by teradata database?
What is FILLER command in Teradata?
What is basic teradata query language?
What are different table types used in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
How is MLOAD Client System restarted after execution?
What are the available primary index types?
can we join volatile table with general table an global temporary table with general table ?
What is a pseudo key? What is its use???