Permanent Table Set Table Multi Set Table derived Table Volatile Table

What are the types of tables in Teradata

Question Posted / kishore

Answer Posted / kishore

Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)

Is This Answer Correct ?

2 Yes

1 No

Please Help Members By Posting Answers For Below Questions

What are the available primary index types?

1280

Describe primary index in teradata?

1053

What is the opening step in basic teradata query script?

1093

Highlight the need for Performance Tuning.

1157

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

1074

How do you see a ddl for an existing table?

1062

How can you track login parameters of users in teradata?

1234

Mention a few of the ETL tools that come under Teradata.

1135

How can we check the version of Teradata that we are using currently?

1111

Explain BYNET.

1056

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3696

What is the difference between union and union all in teradata?

1195

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

1040

What is the syntax for case when statement?

1219

Why do you get spool space errors? How do trouble-shoot them?

1094