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

Answer / pandit

Derived Tables: Tables created for subquery. these are
Query specific. Once the query is over they are dropped.

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)

Answer / tdguy

Following are the types:

VOLATILE TABLES,DERIVED TABLES,GLOBAL TEMPORARY TABLES,
SET/MULTISET TABLES

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 .

Answer / rd

1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE

Answer / alok dubey

Types of Tables Teradata
Set
Multiset

Types of Temporary Tables in Teradata
Global Temporary Tables
Volatile Temporary Tables

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)

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)

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.

If the table does not have duplicates then which utility you can suggest to load the data ?

3 Answers  

What is meant by Teradata Gateway?

0 Answers  

We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.

2 Answers   IBM,

Explain teradata utilities. What is multiload, fast load, tpump?

0 Answers  

How do you load Multiple files to a table by using fastload scripts?

1 Answers   Satyam,

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

5 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,

"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me

9 Answers  

In BTEQ, how are the session-mode parameters being set?

0 Answers  

What is the purpose of upsert command?

0 Answers  

Highlight all the modes that are present under Confidence Level.

0 Answers  

what is DYNAMIC SQL in TD?

1 Answers   IBM,