What are the types of tables in Teradata
- 22 Answers
- 70282 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 various reporting tools in the market?
Describe primary index in teradata. And what are the available primary index types?
Explain teradata utilities. What is multiload, fast load, tpump?
What are the different table types that are supported by teradata?
What is TPD?
Explain fallback in teradata?
Which is faster fastload or multiload?
What is logical data model?
What is collect statistics?
What is partitioned primary index (ppi)?
Which is more efficient group by or distinct to find duplicates?
Explain the advantages of partitioned primary index in a query?
How do you create tables? Exact syntax, and create profiles, users in teradata?
any one answer me how they can analyzing the project using data ware housing?
how do you manage the production space. what are the proactive methods you can take ?
