What are the types of tables in Teradata




Answers were Sorted based on User's Feedback



What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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 ?    29 Yes 3 No

What are the types of tables in Teradata..

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 ?    20 Yes 0 No




What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

What are the types of tables in Teradata..

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

Post New Answer



More Teradata Interview Questions

If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?

1 Answers   Teradata,


How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale

1 Answers  


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


How many macros we can create inside a macro

1 Answers   Wipro,


What is meant by MATCHTAG in multiload utility?

2 Answers   Satyam,






can we have an unconnected lkp to lookup a DB2 record against a Teradata record?

1 Answers   IBM,


IS IT POSSIBLE THAT THERE R TWO PRIMARY KEY WILL BE IN A SAME TABLE?PLZ HELP ME BY GIVING THE ANSWER.THANK U.

10 Answers  


TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)

2 Answers   TCS,


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  


If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

0 Answers  


Difference between Teradata V2R5 and Teradata V12 versions?

2 Answers   IBM,


what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)

4 Answers  






Categories