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

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

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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is a node in teradata?

993

What are the uses of bynets in multi-node systems?

1027

if collect stats but it show low confidence why?

1683

What is the purpose of indexes?

1069

What are the various indexes in teradata?

1044

Give the sizes of SMALLINT, BYTEINT and INTEGER.

1162

Highlight a few of the advantages that ETL tools have over Teradata.

1086

What is bteq utility in teradata?

963

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

1045

How to run a query in teradata?

1065

Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?

2113

What are the functions of a teradata dba?

1070

What are default access rights in teradata? What explicit right can be given to a user?

1108

What are teradata utilities?

1107

What interface is used to connect to windows based applications?

1108