Interview Questions   Tutorials   Discussions   Programs   

Teradata - What are the types of tables in Teradata?

    Next Topic

asked mar September 20, 2014 06:38 AM  

What are the types of tables in Teradata?


1 Answers

answered By vishnoiprem   0  
The following table types exists in Teradata:

Permanent Table - Once created, remains in the database until it is dropped. It can be shared with different sessions and users.
1. SET table - Strictly NO duplicate values [By-Default]
2. MULTISET table - Allows Duplicate Values.

Temporary Tables:

1.Volatile Table - Only the session in which it is created can access the table structure and data. Session ends, table gets dropped.
2.Global Temporary Table - Once created, the structure can be shared with different sessions and users but the data remains private to the session who loaded it. Session ends, its private data gets deleted.

Derived Table - A type of temporary table derived from one or more other tables as the result of a sub-query.
Queue Table - Permanent tables with timestamp column which indicates when each row was inserted.
Error Logging Table - Stores errors of an associated permanent table.
NoPI Table - Permanent tables that do not have any primary index defined on them.
   add comment

Your answer

Join with account you already have



Ready to start your tutorial with us? That's great! Send us an email and we will get back to you as soon as possible!