What are the types of tables in Teradata
- 22 Answers
- 70380 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 are the different softwares used with their functions in teradata?
Differentiate database data and data warehouse data?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What is the use of virtual processor connectivity in teradata?
What are the different table types supported by teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How does hashing happens in teradata?
How many sessions of MAX is PE capable of handling at a particular time?
Describe the between keyword in teradata?
What is a clique?
Explain teradata architecture?
What is the maximum number of dml can be coded in a multiload script?
What are the joins in teradata?
Where is teradata rdbms used?
what is object level locking ? where do appear this type of locking ?
