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 |
What are the different table types that are supported by teradata?
What is teradata?
How many types of joins are there in teradata?
Explain Teradata performance tuning and optimization?
Highlight all the modes that are present under Confidence Level.
What are the design features involved in teradata?
How is Teradata in current market?
How would you load a very large file in teradata in general?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What is the difference between SI and JI?
Explain some differences between mpp and smp?
What is real time and near real time data warehousing?