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 |
Define views in teradata with syntax.
what is identity columns in TD?
What are the scenarios in which full table scans occurs?
which utitility can use for loading the data from non-teradata to teradata ?
Hi All, can anyone tell me how many types of Skew exists? whats the difference between amp skew,data skew,cpu skew, io skew, delta amp cpu ?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
what is single value and Multivalue ?
Highlight all the modes that are present under Confidence Level.
How does indexing improve query performance?
What is meant by a Channel Driver?
What is the purpose of joins in teradata and what are the available join types?