Answer / arun reddy

1.PERMANENT TABLE
2.INTERM TABLE
3.SET TABLE
4.MULTISET TABLE
5.VOLATILE TABLE
6.GLOBAL TEMPORARY TABLE
7.DERIVED TABLE

Answer / pandit

Derived Tables: Tables created for subquery. these are
Query specific. Once the query is over they are dropped.

Answer / kishore

Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)

Answer / tdguy

Following are the types:

VOLATILE TABLES,DERIVED TABLES,GLOBAL TEMPORARY TABLES,
SET/MULTISET TABLES

Answer / ravi

We know that in Teradata all the tables are either SET or MULTISET.
The difference between SET and MULTISET tables is –
SET tables – SET tables did not allow duplicate values in the table.
MULTISET tables – MULTISET tables allow duplicate values in table.

Many of us already defined the temporary tables and permanent table .

Type of Temporary Table :
1) Global temporary Table : GTT can be either SET or Multiset .
2) Volatile Table : It can be either SET or Multiset .
3) Derived Table : they are specified on a query level with an AS keyword in
an sql ststment.


Permanent Table : Permanent Table DDL as well as data stored in Permanent Space . It can be either Set or Multiset .

Answer / rd

1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE

Answer / alok dubey

Types of Tables Teradata
Set
Multiset

Types of Temporary Tables in Teradata
Global Temporary Tables
Volatile Temporary Tables

Answer / ram

Permanent Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTI SET table - Allows Duplicate Values.

Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.
3 derived able
4 error table(t13)

Answer / venkatarayudu gutta

as per my knowledge we have,correct me if i am wrong
1.permanent table
2.set table
3.multiset table
4.derived table
5.error table
6.volatile table
7.global temporary table
and two more we have
8.queue table
9.temporal table(released in TD14)

Answer / maruthi

create insert drop delete
sys    sys    sys  sys-------------derived table
user   user   sys  sys-------------volatile table
user   user   user sys--------------global temp table
user   user   user user-------------normal table


-->derived table will be created by system while executing sub queries
-->global temp table & volatile table has to be created by user by mentioning "global temporary table" , "volatile table" respectively  in the syntax at the time of creating the table.

What is meant by a Least Cost Plan?

0 Answers  

What are the string manipulation operators and functions associated with teradata?

0 Answers  

What is difference between user and database in teradata?

0 Answers  

How to eliminate product joins in a teradata sql query?

0 Answers  

sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?

3 Answers   CTS,

What are the commands to make a new table, change a table and remove a table in teradata?

0 Answers  

what is single value and Multivalue ?

1 Answers   IBM, Wipro,

Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD

6 Answers   Wipro,

What tools would you use for that?

0 Answers  

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

0 Answers  

if a error occured in FASTLOAD is the fastload job stops?

1 Answers   CTS, Deloitte,

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

0 Answers