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

Explain some differences between mpp and smp?

1104

What do high confidence, low confidence and no confidence mean in explain plan?

1048

Define views in teradata with syntax.

1078

If a Node is busy what are the steps you can take to avoid ?

2416

What is multi insert?

1053

Explain teradata architecture?

1094

Explain the types of join supports by teradata?

995

What are the string manipulation operators and functions associated with teradata?

1092

What are the different methods ot loading a dimension table? A fact table etc?

1036

Give a justifiable reason why Multi-load supports NUSI instead of USI.

1154

What are teradata utilities?

1111

Comment whether bottleneck is an error or not.

1159

What are the primary characteristics of the Teradata.

1157

What is the meaning of Caching in Teradata?

1141

What are the different design perspectives used in teradata?

983