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

tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you

359

What is difference between user and database in teradata?

607

Can you fastexport a field, which is primary key by putting equality on that key?

701

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

568

What are the various etl tools in the market?

572

Can we collect statistics on multiple columns?

551

What's the difference between timestamp (0) and timestamp (6)?

619

Highlight the limitations of TPUMP Utility.

596

Explain and compare pros and cons of snow flake schemas?

597

What are the different design perspectives used in teradata?

538

Explain the parallel data extension in teradata?

642

What is upsert statement in teradata?

601

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

577

What do you mean by fastexport in teradata?

544

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

1542