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 |
How to view every column and the columns contained in indexes in teradata?
Can you connect multiload from ab initio?
During the Display time, how is the sequence generated by Teradata?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
What do you mean by teradata intellicloud?
what is amp plz explanation
Can any one plz provide the teradata interview questions?
Highlight all the modes that are present under Confidence Level.
How is the teradata different from oracle?
Which is faster fastload or multiload?
What is the use of having index on table?