how do you handle ET and UV errors ?
Answers were Sorted based on User's Feedback
Answer / tdguy
In mload ET and UV tables, source sequence of the error
records in the input file would be present. Use that number
and delete/correct the records in the input file and submit
the mload job again.
Is This Answer Correct ? | 7 Yes | 0 No |
Answer / yuvaevergreen
applyseq,dmlseq,errorcode,errorfield,hostdata,stmtseq,sourceseq
are the fields in the error table which can be used to
identify the particular sql statement and the data in the
input file.
Is This Answer Correct ? | 3 Yes | 0 No |
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
In Teradata, what is the significance of UPSERT command?
Explain teradata architecture?
How to copy teradata scripts from ur remote desktop to server machine?
What are the newly developed features of Teradata?
What is the meaning of Caching in Teradata?
Explain vproc in teradata?
write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?
How to run the Teradata jobs in unix environment ???
What are the different softwares used with their functions in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
which option is used to restart the fastexport script ?