Interested to Buy Any Domain ? << Click Here >> for more details...
how to load or extract the error table data ?
- 3 Answers
- 7453 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 |
What does sleep function does in fast load?
What are the advantages of teradata?
Explain the term 'database' related to relational database management system?
What are the various indexes in teradata?
Did you write stored procedures in teradata?
What are the enhanced features in teradata v2r5 and v2r6?
What do you mean by parsing?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
In your project what type of issues and errors you facing in Teradata
What is spool space?
What is the purpose of upsert command?
can we join volatile table with general table an global temporary table with general table ?
Teradata 
