What are the types of tables in Teradata

Answer Posted / kishore

Permanent Table
Set Table
Multi Set Table
derived Table
Volatile Table
Global temporary Table
Error Table
Queue Table
temporal Table(from TD13.10)

Is This Answer Correct ?    2 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

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

1315


What is meant by a Highest Cost Plan?

619


Highlight the differences between Primary Key and Primary Index.

612


What is the opening step in basic teradata query script?

592


What is smp and mpp platforms?

524






Highlight a few of the important components of Teradata?

582


How is MLOAD Teradata Server restarted after execution?

646


What is the multi-insert?

607


When tpump is used instead of multiload?

625


In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?

569


What interface is used to connect to windows based applications?

580


What are the uses of bynets in multi-node systems?

584


What is meant by a Least Cost Plan?

618


How does hashing happens in teradata?

619


What are the steps involved in the process flow of the sql statement through channel attached system?

655