What are the types of tables in Teradata
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
How will you solve the problem that occurs during update?
In BTEQ, how are the session-mode parameters being set?
What are the advantages of teradata?
How to Extract data from multiple legacy systems?
Write a program to show the parser component used in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Explain the types of join supports by teradata?
What are the different functions performed in development phase?
Can you connect multiload from ab initio?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
Comment whether bottleneck is an error or not.
Explain PDE.
Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!
What is logical data model?