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 are some commonly used bteq scripts?

558

---

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

531

---

How do you see a ddl for an existing table?

566

---

How will you solve the problem that occurs during update?

574

---

How to run a query in teradata?

576

---

---

What are the functions of a Parser?

602

---

Describe the set operators in teradata.

576

---

What is spool space?

596

---

What is the multi-insert?

604

---

i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1761

---

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1689

---

What is meant by a Highest Cost Plan?

617

---

How to identify ppi columns?

646

---

What is the function of parser component in teradata?

614

---

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

3107

---