What are the types of tables in Teradata
Answer Posted / ravi
We know that in Teradata all the tables are either SET or MULTISET.
The difference between SET and MULTISET tables is –
SET tables – SET tables did not allow duplicate values in the table.
MULTISET tables – MULTISET tables allow duplicate values in table.
Many of us already defined the temporary tables and permanent table .
Type of Temporary Table :
1) Global temporary Table : GTT can be either SET or Multiset .
2) Volatile Table : It can be either SET or Multiset .
3) Derived Table : they are specified on a query level with an AS keyword in
an sql ststment.
Permanent Table : Permanent Table DDL as well as data stored in Permanent Space . It can be either Set or Multiset .
Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is teradata?
What is the difference between fastload and multiload?
What are the various indexes in teradata?
How is MLOAD Teradata Server restarted after execution?
What tools would you use for that?
What are some primary characteristics of teradata?
What are the various indexes in teradata? How to use them?
What is the primary index in teradata?
What are the main components of teradata system?
What do you mean by caching in teradata?
Explain parsing engine in teradata?
what are the day to day activities of teradata DBA ?
Describe the set operators in teradata.
What does Amp contain and what are all the operations that it performs?
How do you see a ddl for an existing table?