Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 77674 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 multi insert?
What are differences between teradata and ansi session modes in teradata?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
How is the teradata different from oracle?
What are the frequently used data types in teradata?
What are the scenarios in which full table scans occurs?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Differentiate primary key and partition key?
What is primary index and secondary index?
What is basic teradata query language?
When tpump is used instead of multiload?
Explain fastload in teradata?
What do you mean by tpt in teradata?
Which is faster fastload or multiload?
What is the purpose of joins in teradata?
