1-- SET TABLE 2-- MULTISET TABLE 3-- PERMANANT TABLE 4-- GLOBAL TEMPORAR

What are the types of tables in Teradata

Question Posted / preeti

22 Answers
78614 Views
Cap Gemini, Cognizant, Infosys, I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How do you do backup and recovery in teradata?

1022

What can be achieved by using the teradata rdbms?

1038

What are the available join types in teradata?

1068

Explain the teradata primary index mechanics in detail with a diagram.

978

What is spool space? Why do you get spool space errors? How do trouble-shoot them?

988

How to find duplicates in a table?

1218

What is the meaning of Caching in Teradata?

1141

What happens when a node suffers a downfall?

1131

What are some primary characteristics of teradata?

1001

Explain and compare pros and cons of start schemas?

1066

Explain the advantages of partitioned primary index in a query?

1028

How does hashing happens in teradata?

1091

Explain the term 'primary key' related to relational database management system?

1036

What do you mean by tpt in teradata?

1021

What is the purpose of upsert command?

1177