Answer Posted / vimal

We can use minus query and intersect query

unmatched: records in a but not in b
select *
from a
minus
select *
from b ;

matched: recrods in a and in b
select *
from a
intersect
select *
from b ;

What are the enhanced features in teradata v2r5 and v2r6?

1184

---

If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

1208

---

What are the functions of a teradata dba?

1126

---

What are the different methods ot loading a dimension table? A fact table etc?

1082

---

What is meant by Teradata Gateway?

1110

---

Why do you get spool space errors? How do trouble-shoot them?

1089

---

why use references rather than pointers in the public api, particularly for arguments which are modified?

1053

---

List out some of the primary characteristics of teradata.

1060

---

What is called partitioned primary index (ppi)?

1054

---

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

1039

---

what are the day to day activities of teradata DBA ?

5860

---

What do you mean by tpt in teradata?

1064

---

What is upsert statement in teradata?

1191

---

What are the joins in teradata?

1071

---

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

1107

---