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 parsing engine in teradata?
Highlight a few of the advantages that ETL tools have over Teradata.
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
What can be achieved by using the teradata rdbms?
What are aggregate tables? How do you design them using teradata?
Can we collect statistics on table level?
Explain the term 'database' related to relational database management system?
What are the joins in teradata and how many types of joins are there in teradata?
What is a clique?
What are the available join types in teradata?
Define views in teradata with general syntax.
Why are oltp database designs not generally a good idea for a data warehouse?
What is the difference between teradata and oracle?
How to load specific no.of records using bteq, or fastload,or multiload
Explain and compare pros and cons of snow flake schemas?