1-- SET TABLE 2-- MULTISET TABLE 3-- GLOBAL TEMPORARY TABLE 4-- VOLATILE

What are the types of tables in Teradata

Question Posted / raghavender

Answer Posted / raghavender

1-- SET TABLE
2-- MULTISET TABLE
3-- GLOBAL TEMPORARY TABLE
4-- VOLATILE TABLE
5-- DERIVED TABLE

Is This Answer Correct ?

11 Yes

4 No

Please Help Members By Posting Answers For Below Questions

Highlight the differences between Primary Key and Primary Index.

1145

What is a clique?

1152

Explain and compare pros and cons of snow flake schemas?

1088

Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

1128

What is the purpose of upsert command?

1261

How to Extract data from multiple legacy systems?

1176

Syntax for case when statement?

1118

What do you mean by teradata intellicloud?

1077

Comment whether bottleneck is an error or not.

1220

How do you see a ddl for an existing table?

1061

My table got locked during mload due to a failed job. What do I do to perform other operations on it?

1156

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

1218

Explain teradata utilities?

1094

What is a sparse index?

1121

What does Amp contain and what are all the operations that it performs?

1054