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
Explain vproc in teradata?
What is real time and near real time data warehousing?
How to run a query in teradata?
What is TPD?
Discuss the advantages of using partitioned primary index in a query?
How is the teradata different from oracle?
Steps to create a data model?
What are the various indexes in teradata? How to use them?
What is meant by a Least Cost Plan?
What is collect statistics?
What is the purpose of upsert command?
What is oltp?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
Difference between inner join and outer join?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?