What are the types of tables in Teradata

Categories >> Software >> Data Warehouse >> Teradata
Suggest New Category

Question Posted / roopesh

22 Answers
78502 Views
Cap Gemini, Cognizant, Infosys, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

What are the types of tables in Teradata..

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

Is This Answer Correct ?

3 Yes

2 No

What are the types of tables in Teradata..

Answer / pandit

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

Is This Answer Correct ?

1 Yes

0 No

What are the types of tables in Teradata..

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)

Is This Answer Correct ?

2 Yes

1 No

What are the types of tables in Teradata..

Answer / tdguy

Following are the types:

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

Is This Answer Correct ?

1 Yes

0 No

What are the types of tables in Teradata..

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 .

Is This Answer Correct ?

1 Yes

0 No

What are the types of tables in Teradata..

Answer / rd

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

Is This Answer Correct ?

9 Yes

9 No

What are the types of tables in Teradata..

Answer / alok dubey

Types of Tables Teradata
Set
Multiset

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

Is This Answer Correct ?

2 Yes

2 No

What are the types of tables in Teradata..

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)

Is This Answer Correct ?

0 Yes

0 No

What are the types of tables in Teradata..

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)

Is This Answer Correct ?

0 Yes

0 No

What are the types of tables in Teradata..

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.

Is This Answer Correct ?

0 Yes

0 No

Post New Answer