Interested to Buy Any Domain ? << Click Here >> for more details...
how do you handle ET and UV errors ?
- 2 Answers
- 10725 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 |
Aborted in Phase 1 data Acquistion Incomplete in fastload?
If the script is aborted. why it is aborted and how can you identify ?
Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Hi frinds pls help me regarding this question WHY usi is two amp operation in teradata? THANKS IN ADVANCE....
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
Explain the term 'database' related to relational database management system?
What is meant by a Least Cost Plan?
What are the various etl tools in the market?
How to relege locks in fastload and multiload? example?
What is meant by a Virtual Disk?
Highlight the advantages of PPI(Partition Primary Index).
Teradata 
