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 purpose of using case expression in teradata?

996

---

While creating table my dba has fallback or no fallback in his ddl. What is that?

1155

---

What is the maximum number of dml can be coded in a multiload script?

1089

---

Why teradata is used?

979

---

What is a three-tier data warehouse?

1093

---

What is teradata?

1117

---

Explain how spool space is used.

1057

---

how can we analyze the locks ?

2102

---

Difference between multiload and tpump?

1078

---

What is oltp?

961

---

Explain fallback in teradata?

1031

---

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

1018

---

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

1936

---

What are the different functions performed in development phase?

1062

---

If a Node is busy what are the steps you can take to avoid ?

2398

---