Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79302 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
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 are the various reporting tools in the market?
Can we collect statistics on table level?
What are the various indexes in teradata? How to use them? Why are they preferred?
Explain the most common data types used in teradata?
How many types of joins are there in teradata?
Differentiate primary key and partition key?
Explain the term 'tables' related to relational database management system?
How you will check the version of teradata?
If a Node is busy what are the steps you can take to avoid ?
What are the components provided on node?
What is upsert statement in teradata?
When tpump is used instead of multiload?
In the Primary Index, what is the score of AMPs that are actively involved?
Describe the between keyword in teradata?
In Teradata, what is the significance of UPSERT command?
