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 meant by Teradata Gateway?

1029

---

What is the use of fallback?

963

---

What is node? How many nodes and amps used in your previous project?

1089

---

What is teradata? Also, list out some of the primary characteristics of teradata.

1012

---

What are the various etl tools in the market?

1038

---

What is TPD?

1332

---

What are the functions involved in shared information architecture?

1045

---

what are the day to day activities of teradata DBA ?

5774

---

What does sleep function does in fast load?

1091

---

How many codd's rules are satisfied by teradata database?

1072

---

Describe primary index in teradata. And what are the available primary index types?

966

---

How will you solve the problem that occurs during update?

1017

---

What are the various indexes in teradata? How to use them? Why are they preferred?

1024

---

Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?

1153

---

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

926

---