I want to write one query How to get Matched records and unmatched records in table?

4 Answers   TCS,

---

What are the various indexes in teradata? How to use them?

0 Answers  

---

Explain how spool space is used.

0 Answers  

---

What do you mean by fastexport in teradata?

0 Answers  

---

How teradata makes sure that there are no duplicate rows being inserted when its a set table?

0 Answers  

---

---

Explain Teradata performance tuning and optimization?

0 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,

---

how teradata fetches a row from primary index table?

1 Answers  

---

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,

---

Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?

9 Answers   IBM,

---

i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,

---

can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

3 Answers  

---