Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78705 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 |
What are the string manipulation operators and functions associated with teradata?
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
How you will check the version of teradata?
What is meant by a Virtual Disk?
Frnds.... i have one doubt we have the num like this +913757575......i want to remove 91 and i want lo load remaining data to the target table.. whinch function we can use in teradata????? Plz let me know.. thanks in advance
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update
How do you create a table with an existing structure of another table with data and with no data?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
List out some of the primary characteristics of teradata.
Highlight all the modes that are present under Confidence Level.
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Teradata 
