Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78503 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
Difference between multiload and tpump?
What are the different functions performed in development phase?
What can be achieved by using the teradata rdbms?
Mention a few of the ETL tools that come under Teradata.
What is bteq utility in teradata?
What is meant by Teradata Gateway?
Name the five phases that come under MultiLoad Utility.
Explain the term 'tables' related to relational database management system?
Explain the term 'primary key' related to relational database management system?
Explain the most common data types used in teradata?
What is the use of having index on table?
how can we analyze the locks ?
How do you verify a complicated sql?
How many codd's rules are satisfied by teradata database?
Explain the teradata primary index mechanics in detail with a diagram.
