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.

How is the teradata different from oracle?

0 Answers  

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

0 Answers  

plz explain parlla distribution and subtable concept in teradata

3 Answers   TCS,

Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  

how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,

Why are oltp database designs not generally a good idea for a data warehouse?

0 Answers  

Which is more efficient group by or distinct to find duplicates?

0 Answers  

Highlight a few of the important components of Teradata?

0 Answers  

in teradata level primary in table level allows duplicates why?

1 Answers   TCS,

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers   IBM, Mphasis,

Hash collision?

3 Answers   Satyam,

How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?

2 Answers   IBM,