Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 77726 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 |
how to load or extract the error table data ?
Why Multiload does not supports USI and supports NUSI?
What is meant by a Least Cost Plan?
How will you solve the problem that occurs during update?
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
Is PK concept available in Teradata. If it is how can we create Primary Key for a table in TD
Describe primary index in teradata?
Define views in teradata with syntax.
can i call router is a passive transformation
What is the use of fallback?
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Teradata 
