Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78035 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
VOLATILE TABLES - Occupies spool space - Data/Definition
dropped when the session ends or user drops it.
DERIVED TABLES - Occupies spool space - Data dropped as
soon as the query ends.
GLOBAL TEMPORARY TABLES - Occupies temporary space - Data
dropped as soon as the user deletes or session ends -
Definition stored permanently in the DD.
SET/MULTISET TABLES - Occupies permanent space -
Data/Definition retained until user deletes it.
| Is This Answer Correct ? | 8 Yes | 0 No |
Post New Answer View All Answers
What is meant by a Virtual Disk?
Highlight the limitations of TPUMP Utility.
how do you manage the production space. what are the proactive methods you can take ?
What do you mean by fastexport in teradata?
What do you mean by caching in teradata?
What are some primary characteristics of teradata?
What is teradata and why it is used?
Difference between multiload and tpump?
What is a sparse index?
Why do you get spool space errors? How do trouble-shoot them?
What is a clique?
How can bottlenecks be identified?
What are types of partition primary index (ppi) in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
what are the day to day activities of teradata DBA ?
