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

What are some commonly used bteq scripts?

970

How to find duplicates in a table?

1168

What is a level of granularity of a fact table?

1101

Describe primary index in teradata. And what are the available primary index types?

967

What are default access rights in teradata?

1074

Explain amp in teradata?

1033

What are the steps involved after the disk manager passes the request?

1062

What is the basic syntax for teradata select statement?

1007

What is a node in teradata? Explain

960

What is the purpose of upsert command?

1116

What are the functions performed by bynet?

1011

How will you solve the problem that occurs during update?

1020

What is the meaning of Caching in Teradata?

1102

What are differences between teradata and ansi session modes in teradata?

1124

How can bottlenecks be identified?

977