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


Please Help Members By Posting Answers For Below Questions

Explain parsing engine in teradata?

564


Highlight a few of the advantages that ETL tools have over Teradata.

583


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?

658


What can be achieved by using the teradata rdbms?

602


What are aggregate tables? How do you design them using teradata?

609






Can we collect statistics on table level?

576


Explain the term 'database' related to relational database management system?

547


What are the joins in teradata and how many types of joins are there in teradata?

543


What is a clique?

562


What are the available join types in teradata?

573


Define views in teradata with general syntax.

544


Why are oltp database designs not generally a good idea for a data warehouse?

575


What is the difference between teradata and oracle?

525


How to load specific no.of records using bteq, or fastload,or multiload

1295


Explain and compare pros and cons of snow flake schemas?

583