Interested to Buy Any Domain ? << Click Here >> for more details...
how to load or extract the error table data ?
- 3 Answers
- 7749 Views
- I also Faced
- E-Mail Answers
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 |
Which Teradata concept allows more than one model generation?
Explain teradata utilities. What is multiload, fast load, tpump?
What is inner join and outer join?
What happens when a node suffers a downfall?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Can we collect statistics on multiple columns?
How does hashing happens in teradata?
What can be achieved by using the teradata rdbms?
Explain parsing engine in teradata?
What is the command in bteq to check for session settings ?
Where is teradata rdbms used?
if collect stats but it show low confidence why?
Teradata 
