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 can bottlenecks be identified?
Why Multiload and Fastload does not supports SI,JI,RI and TRIGGERS?
Why Fload doesn’t support multiset table?
What are the joins in teradata?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
If RDBMS is halted what will you do ?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
What is a dimension table?
How to Skip or Get first and Last Record from Flat File through MultiLoad and TPUMP Utility?
whether Nulls will be counted while doing average? example: we have table column A with following values A -- 5 Null 8 3 Now what is the average of A?
Which is faster fastload or multiload?
While creating table my dba has fallback or no fallback in his ddl. What is that?