What are the types of tables in Teradata

Question Posted / roopesh

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

Answers were Sorted based on User's Feedback

What are the types of tables in Teradata..

Answer / vinay

As far as i my knoweledge goes we have ,correct me if i am
wrong.

1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
5 VOLATILE TEMPORARY TABLES
These are the five kind of tables.

Is This Answer Correct ?

12 Yes

17 No

What are the types of tables in Teradata..

Answer / vinay

as far as i my knoweledge goes we have ,correct me if i am
wrong.

1 SET
2 MULTI SET
3 GLOBAL TEMPORARY TABLES
4 TEMPORARY TABLES
and there is one more i reckon which i cant remember.

Is This Answer Correct ?

7 Yes

25 No

Post New Answer

More Teradata Interview Questions

Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR

4 Answers Cap Gemini,

How you will check the version of teradata?

0 Answers

Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance

4 Answers IBM,

write a query following data. 123.45 is input.write a query after decimal (ex:.45) load into database ?how it possible?

3 Answers IBM,

Where we use PPI in real time??? What is the disadvantages of PPI?

3 Answers IBM, Mphasis,

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

0 Answers

What is a dimension table?

0 Answers

What is the difference between teradata and basic rdbms?

0 Answers

Difference between Teradata V2R5 and Teradata V12 versions?

2 Answers IBM,

What are different table types used in teradata?

0 Answers

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?

0 Answers IBM,

in ur table contains the coloumns like deptno,sal empname then i want output as deptno subtotalofdept totalsal 10 3700 3700 20 3400 7100 like that

1 Answers IBM,

For more Teradata Interview Questions Click Here