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 spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What do you mean by teradata sql assistant?
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
Comment whether bottleneck is an error or not.
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the teradata primary index mechanics in detail with a diagram.
what happen if a query fail in dispatcher?
Explain the term 'primary key' related to relational database management system?
Explain amp in teradata?
What is meant by a Parsing Engine?
What are default access rights in teradata?