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
79314 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

Why does varchar occupy 2 extra bytes?

1272

What are types of partition primary index (ppi) in teradata?

1101

Explain Teradata performance tuning and optimization?

1223

In the Primary Index, what is the score of AMPs that are actively involved?

1129

What is multi insert?

1111

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1215

Difference between star and snowflake schemas?

1249

What is meant by a Channel Driver?

1334

Why teradata is used?

1059

Which is more efficient group by or distinct to find duplicates?

1133

While creating table my dba has fallback or no fallback in his ddl. What is that?

1243

What is the primary index in teradata?

1286

List out teradata data types?

1064

What do you mean by parsing?

1163

Explain the meaning of Amp?

1241