What are the types of tables in Teradata

Answer Posted / ramya

TEMPORARY TABLES
1. Global Temporary Table
2. Derived Table
3. Volatile Table

PERMANENT Table

1. SET Table
2. MULTISET Table

Is This Answer Correct ?    16 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by teradata intelliflex?

631


What is upsert statement in teradata?

613


What are teradata utilities?

587


how many modules are there in telecome domain?how to explain the architecture?

1557


How do you define Teradata?

607






Explain the teradata primary index mechanics in detail with a diagram.

567


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

532


Which is more efficient group by or distinct to find duplicates?

646


Explain teradata vs. Redshift?

559


Name the five phases that come under MultiLoad Utility.

586


Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.

590


What is TPD?

907


Why do you get spool space errors? How do trouble-shoot them?

592


What are differences between teradata and ansi session modes in teradata?

622


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

597