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 difference between user and database in teradata?

1112

---

What are aggregate tables? How do you design them using teradata?

1214

---

What are normalization, first normal form, second normal form and third normal form?

1098

---

Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

1081

---

What is the command in bteq to check for session settings ?

1230

---

What does sleep function does in fast load?

1204

---

How do you see a ddl for an existing table?

1058

---

What is the particular designated level at which a LOCK is liable to be applied in Teradata?

1084

---

What are some commonly used bteq scripts?

1056

---

How does hashing happens in teradata?

1144

---

What are the different design perspectives used in teradata?

1031

---

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

1038

---

How many sessions of MAX is PE capable of handling at a particular time?

1133

---

Explain the term 'primary key' related to relational database management system?

1087

---

Explain teradata architecture in detail with a diagram.

1164

---