Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79317 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / rajesh kumar
Permenant Tables:
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET table - Allows Duplicate Values.
Temporary Tables:
1. Global Temporary Table - supports [Compression in table],
when session logged out, Table persists and its record gets
vanished.
2. Volatile Table - When session logged out, TABLE and its
records are not available further.
I dont have idea about Derived Table, could someone
elaborate on this?
| Is This Answer Correct ? | 31 Yes | 3 No |
Post New Answer View All Answers
What is stored procedure in teradata?
What are the scenarios in which full table scans occurs?
What is TPD?
What is meant by a Highest Cost Plan?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
How to find duplicates in a table?
Explain the term 'foreign key' related to relational database management system?
Explain the term 'columns' related to relational database management system?
Explain the term 'row' related to relational database management system?
What is difference between user and database in teradata?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Why does varchar occupy 2 extra bytes?
What is meant by a Clique?
Explain teradata vs. Redshift?
What is a clique?
