how do you handle ET and UV errors ?
- 2 Answers
- 10134 Views
- I also Faced
- E-Mail Answers
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 is identity columns in teradata
in teradata level primary in table level allows duplicates why?
What are the different functions performed in development phase?
What is a pseudo key? What is its use???
What do you mean by teradata sql assistant?
teradata support to automatically increase the character length or not?
What is the purpose of using case expression in teradata?
What is differnce between Error code and Error Level in Bteq
Why MLOAD needs Work Tables?
What is called partitioned primary index (ppi)?
What is the opening step in basic teradata query script?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Teradata 
