Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 77889 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / terad
Types of Tables in Teradata :
1.Derived
2.Volatile
3.Global Temp.
4.Permanent
4.1. SET
4.2. Multiset
| Is This Answer Correct ? | 61 Yes | 1 No |
Answer / rajesh kumar
Permenant Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET 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.
I dont have idea about Derived Table, could someone
elaborate on this?
| Is This Answer Correct ? | 31 Yes | 3 No |
Answer / rajesh kumar
update on previous answer:
1.Derived table stores the derived result from a subquery.
2.It uses only spool space, so no table definition,
permission needed.
simple query eg:
select * from (select max(sal) from emp) DT (Max_sal)
answer:
derived table(DT) has Max salary and result would be
Max_sal- here subquery result is maintained in derived table
-------
25000
3. derived table auto drops after the query ends
| Is This Answer Correct ? | 22 Yes | 0 No |
Answer / preeti
1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE
7--INTERIM TABLES
| Is This Answer Correct ? | 25 Yes | 9 No |
Answer / ramya
TEMPORARY TABLES
1. Global Temporary Table
2. Derived Table
3. Volatile Table
PERMANENT Table
1. SET Table
2. MULTISET Table
| Is This Answer Correct ? | 16 Yes | 0 No |
Answer / yuvaevergreen
VOLATILE TABLES - Occupies spool space - Data/Definition
dropped when the session ends or user drops it.
DERIVED TABLES - Occupies spool space - Data dropped as
soon as the query ends.
GLOBAL TEMPORARY TABLES - Occupies temporary space - Data
dropped as soon as the user deletes or session ends -
Definition stored permanently in the DD.
SET/MULTISET TABLES - Occupies permanent space -
Data/Definition retained until user deletes it.
| Is This Answer Correct ? | 8 Yes | 0 No |
Answer / raghavender
1-- SET TABLE
2-- MULTISET TABLE
3-- GLOBAL TEMPORARY TABLE
4-- VOLATILE TABLE
5-- DERIVED TABLE
| Is This Answer Correct ? | 11 Yes | 4 No |
Answer / teja
Derived temporary tables
# Derived tables are local to an SQL query.
# Not included in the DBC data dictionary database, the
definition is kept in cache.
# They are specified on a query level with an AS keyword
in an sql statement
| Is This Answer Correct ? | 5 Yes | 0 No |
Answer / ravi bandi
permanent tables:
1.set---which thow out any rows that complete duplicates
2.mutiset--which allows multiple instances for same row.
temporary tables:
1.global temporary tables-- when it is created its
definition stored on data dictionary. the data will be
stored on temp space that's why data is active upto the
session ends, we can collect statistics on GTT.
2.volatile temporary tables--when it is created the
definition is stored on cache.the data will be stored in
spool space,thats why data and table defition both are
active up to session ends.you can't collect statistics on
VTT.
3.derived tables-- when we created the definition is stored
on cache.it is local to an sql query.
they are specified on a query level with an AS keyword in
an sql ststment.
| Is This Answer Correct ? | 3 Yes | 0 No |
Answer / nani
continuation of rajesh kumar.
3.when we can use the select statement in form clause and
specify the name with 'as' keyword for that statement is
called derived table
| Is This Answer Correct ? | 3 Yes | 0 No |
How would you load a very large file in teradata in general? What utility would you use for it? Why?
What are types of partition primary index (ppi) in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
Can you load multiple data files for same target table using fastload?
Which Teradata concept allows more than one model generation?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Explain and compare pros and cons of start schemas?
Is multi insert ansi standard?
Why does varchar occupy 2 extra bytes?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Why FLOAD does not support multiset tables??
Teradata 
