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

What are the types of tables in Teradata

Question Posted / ramya

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

Please Help Members By Posting Answers For Below Questions

Highlight the need for Performance Tuning.

592

How is the teradata different from oracle?

626

Hi Friends, Please send me Teradata Materials for certifications Thanks in advance !!

1699

How to find duplicates in a table?

612

What is multi insert?

628

How can we check the version of Teradata that we are using currently?

593

What are the primary characteristics of the Teradata.

593

When tpump is used instead of multiload?

629

Describe primary index in teradata?

588

Describe the set operators in teradata.

583

List out some of the primary characteristics of teradata.

558

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3000

Name the five phases that come under MultiLoad Utility.

586

What are the available primary index types in teradata.

589

Differentiate primary key and partition key?

581