Interested to Buy Any Domain ? << Click Here >> for more details...
how to load or extract the error table data ?
- 3 Answers
- 7761 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 |
Explain how spool space is used.
I WANT TO LEARN TERA-DATA ,SO CAN ANY BODY PLZ REFER WHAT ARE THE TOPICS I HAVE TO GO THROUGH, TO GET ASAP JOB ,SO PLZ REFER ME WHERE I CAN GET NICE COACHING ON TERADATA.
What are the joins in teradata and how many types of joins are there in teradata?
Why FLOAD does not support multiset tables??
What are the various indexes in teradata? How to use them?
What is the use of having index on table?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
What is node? How many nodes and amps used in your previous project?
Explain parsing engine in teradata?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
What happens when a node suffers a downfall?
Can you fastexport a field, which is primary key by putting equality on that key?
Teradata 
