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 object level locking ? where do appear this type of locking ?

3500

---

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

2182

---

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

1080

---

how many modules are there in telecome domain?how to explain the architecture?

2016

---

What is meant by a node?

1041

---

What is teradata and why it is used?

1099

---

What is logical data model?

1205

---

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

1055

---

how can we analyze the locks ?

2132

---

Explain how spool space is used.

1077

---

If RDBMS is halted what will you do ?

2169

---

Explain the term 'columns' related to relational database management system?

1068

---

Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1955

---

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

2202

---

Differentiate database data and data warehouse data?

1117

---