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 |
Highlight a few of the important components of Teradata?
What is real time and near real time data warehousing?
What do you mean by teradata sql assistant?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
IBM QUESTION As all we know PE takes the SQL Request and it will give responce for that query. what is the internal process happening.how it is taking that sql from the system????? thanks in Advance
2 Answers Cap Gemini, IBM, Infosys,
1.what is activity count? 2.what is skew factor? how it's working explain brefily
Explain the types of join supports by teradata?
What is meant by a Highest Cost Plan?
Define views in teradata with syntax.
what is use of PI(primary index) AND SI(secondary index)