Answer Posted / rkraju

yes we can join volatile to general table;
>> first we create volatile table
syntax:
create volatile table vt1(x int,y int)on commit preserve rows;
>> we can create general table
syntax:
create table t1(x int,y int,z int);
>>now we can join volatile table and general table
Eg:
select a.x,b.x from vt1 a,t1 b where a.x=b.x;

What is the use of virtual processor connectivity in teradata?

769

---

Write a program to show the parser component used in teradata?

729

---

List the logical and conditional operators that are used with teradata along with their meanings?

739

---

What's the difference between timestamp (0) and timestamp (6)?

891

---

what is object level locking ? where do appear this type of locking ?

3288

---

Discuss the advantages of using partitioned primary index in a query?

711

---

What is the basic syntax for teradata select statement?

757

---

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

745

---

what are the day to day activities of teradata DBA ?

5562

---

Highlight the advantages of PPI(Partition Primary Index).

773

---

Highlight the differences between Primary Key and Primary Index.

803

---

What is a node in teradata?

741

---

What is spool space? Why do you get spool space errors?

684

---

What are the steps involved in the process flow of the sql statement through channel attached system?

853

---

What are the different softwares used with their functions in teradata?

766

---