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.

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.

How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  

---

What is use of compress in terdata?Explain?

11 Answers  

---

I want to load 1000 rcds using. FL for every 100 records there is a check point.But script failed at 120 records, when we are restarting the script, it starts from last ckpt, but Target table contains populated data but FL doesnt support existing data in target table. How can we load data in FL?

4 Answers   IBM,

---

Does any body has TERADATA Certification Dumps, if any body is having please let me know to summee4you@gmail.o, it is very Very URGENT to me

25 Answers   TCS,

---

Can some one tell me the ressolution for the error. I was not able to answer this question in wipro interview. "The transaction exceeded the maximum number of rowhash locks allowed"

1 Answers   Wipro,

---

How many types of index are present in teradata?

1 Answers  

---

What do high confidence, low confidence and no confidence mean in explain plan?

0 Answers  

---

we have two tables emp,dept.emp has eno,ename,sal and dept has deptno,dname.how to find maxsal of each dept wise.which join used for joining.

5 Answers   Accenture, Cognizant,

---

what is the structure of UV table in MLOAD?

4 Answers   Cap Gemini,

---

What are differences between teradata and ansi session modes in teradata?

0 Answers  

---

1.what is activity count? 2.what is skew factor? how it's working explain brefily

5 Answers   Satyam,

---

List out teradata data types?

0 Answers  

---