Answer Posted / ravi bandi

permanent tables:
1.set---which thow out any rows that complete duplicates
2.mutiset--which allows multiple instances for same row.

temporary tables:

1.global temporary tables-- when it is created its
definition stored on data dictionary. the data will be
stored on temp space that's why data is active upto the
session ends, we can collect statistics on GTT.
2.volatile temporary tables--when it is created the
definition is stored on cache.the data will be stored in
spool space,thats why data and table defition both are
active up to session ends.you can't collect statistics on
VTT.
3.derived tables-- when we created the definition is stored
on cache.it is local to an sql query.
they are specified on a query level with an AS keyword in
an sql ststment.

If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

2168

---

Explain vproc in teradata?

1007

---

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1081

---

How to view every column and the columns contained in indexes in teradata?

1056

---

Explain teradata architecture?

1098

---

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

1038

---

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

1011

---

What is the function of parser component in teradata?

1088

---

What are normalization, first normal form, second normal form and third normal form?

1058

---

Why are oltp database designs not generally a good idea for a data warehouse?

1057

---

any one answer me how they can analyzing the project using data ware housing?

2481

---

How do you do backup and recovery in teradata?

1023

---

Where is teradata rdbms used?

1102

---

What is basic teradata query language?

1118

---

What is meant by a dispatcher?

1021

---