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
What does sleep function does in fast load?
What are the design features involved in teradata?
What are the various etl tools in the market?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What do you mean by teradata sql assistant?
What is multi insert?
What are some commonly used bteq scripts?
What is the primary index in teradata?
How is the teradata different from oracle?
What is node? How many nodes and amps used in your previous project?
What do you mean by ttu in teradata?
What is the use of fallback?
Explain the parallel data extension in teradata?
What are types of partition primary index (ppi) in teradata?
What are the functions involved in shared information architecture?