how do you handle ET and UV errors ?

Answers were Sorted based on User's Feedback



how do you handle ET and UV errors ?..

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

how do you handle ET and UV errors ?..

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

Post New Answer

More Teradata Interview Questions

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

2 Answers   IBM,


In Teradata, what is the significance of UPSERT command?

0 Answers  


Explain teradata architecture?

0 Answers  


How to copy teradata scripts from ur remote desktop to server machine?

3 Answers  


What are the newly developed features of Teradata?

0 Answers  






What is the meaning of Caching in Teradata?

0 Answers  


Explain vproc in teradata?

0 Answers  


write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers   IBM,


How to run the Teradata jobs in unix environment ???

4 Answers   IBM,


What are the different softwares used with their functions in teradata?

0 Answers  


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

0 Answers  


which option is used to restart the fastexport script ?

2 Answers   TCS,


Categories