1.

Explain various table types supported by Teradata.

Answer»

The FOLLOWING types of tables are SUPPORTED by Teradata:  

  • Permanent Table: This table contains all the data INSERTED by the user and stores the data permanently after it has been entered in the table. The content of permanent tables can be shared between different sessions and users. It is the default table. 
  • Volatile Table: When data is added to a volatile table, it is only retained during the current session, and the table is automatically dropped after the user session ends. They are generally used to store data that is intermediate during data transformation. 
  • Global Temporary Table: Other types of permanent tables include global temporary tables. This type of table stores the globally used VALUES for the entire APPLICATION, and its lifetime is dependent on the session of the user. Upon the end of the session, the table is deleted/dropped. 
  • Derived Table: Among all the tables, derived tables have the shortest lifetime. During query execution, intermediate results of queries are stored in these tables. Tables are created, used, and then dropped in the course of a query.


Discussion

No Comment Found