What are different table types used in Teradata?
There have four table types supported in Teradata:
- Permanent Table: It’s the default table and contains data put by the user and stores that data permanently.
- Global Temporary Table: Persistent but the data present in the table will be deleted at the end of the user session.
- Volatile Table: The data into this table is retained only during the user session.
- Derived Table: It holds the intermediate results in a query. The lifetime of this table depends on the query in which they are created, dropped and used.
This is a fundamental question in teradata interview questions.
BY Best Interview Question ON 06 Mar 2019