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 |
What are normalization, first normal form, second normal form and third normal form?
1.what is activity count? 2.what is skew factor? how it's working explain brefily
Can we collect statistics on table level?
Aborted in Phase 2 data acquistion completed in fastload?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
How to run a query in teradata?
How do you load Multiple files to a table by using fastload scripts?
Explain some differences between mpp and smp?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
What is the difference between fastload and multiload? Which one is faster?
What are the components provided on node?
Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me