Interested to Buy Any Domain ? << Click Here >> for more details...
how do you handle ET and UV errors ?
- 2 Answers
- 10835 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 meant by a Parsing Engine?
What is the difference between fastload and multiload?
What is the difference between fastload and multiload? Which one is faster?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What are the different softwares used with their functions in teradata?
1.what is activity count? 2.what is skew factor? how it's working explain brefily
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are the components used in smp and massively parallel processing (mpp) machines?
Where we use PPI in real time??? What is the disadvantages of PPI?
Diff b/w v2r5 and v2r6 ?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
Teradata 
