1.PERMANENT TABLE 2.INTERM TABLE 3.SET TABLE 4.MULTISET TABLE 5.VOLATIL

What are the types of tables in Teradata

Question Posted / arun reddy

Answer Posted / arun reddy

1.PERMANENT TABLE
2.INTERM TABLE
3.SET TABLE
4.MULTISET TABLE
5.VOLATILE TABLE
6.GLOBAL TEMPORARY TABLE
7.DERIVED TABLE

Is This Answer Correct ?

3 Yes

2 No

Please Help Members By Posting Answers For Below Questions

What are the various etl tools in the market?

1016

What is a three-tier data warehouse?

1053

What are the different design perspectives used in teradata?

926

Why is the case expression used in teradata?

1023

Explain the term 'row' related to relational database management system?

886

What are the things to be considered while creating secondary index?

1033

What are the joins in teradata and how many types of joins are there in teradata?

959

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

1086

Explain the meaning of Amp?

1033

How many tables can you join in v2r5?

997

In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

1091

Explain teradata architecture in detail with a diagram.

1049

How would you load a very large file in teradata in general? What utility would you use for it? Why?

1032

What do you mean by ttu in teradata?

972

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1104