What are the types of tables in Teradata
- 22 Answers
- 70123 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
Answer / tdguy
Following are the types:
VOLATILE TABLES,DERIVED TABLES,GLOBAL TEMPORARY TABLES,
SET/MULTISET TABLES
| Is This Answer Correct ? | 1 Yes | 0 No |
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 |
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 |
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 |
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 |
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 |
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 |
Why does varchar occupy 2 extra bytes?
What is logical data model?
what is object level locking ? where do appear this type of locking ?
How to run the Teradata jobs in unix environment ???
Explain parsing engine in teradata?
Which is faster fastload or multiload?
Can we take collect stats on Dervied Tables and Volitable tables, What is Golabal Temporary table what is the use of this Golabal Temporary table ,When we create any kind table in Teradata it will show in Golabal Temporary table
What are two examples of an OLTP environment?
What is real time and near real time data warehousing?
What are the various reporting tools in the market?
What is meant by a node?
What are the components used in smp and massively parallel processing (mpp) machines?
Teradata 
