What are the types of tables in Teradata
- 22 Answers
- 70265 Views
- Cap Gemini, Cognizant, Infosys, I also Faced
- E-Mail Answers
Answer Posted / teja
Derived temporary tables
# Derived tables are local to an SQL query.
# Not included in the DBC data dictionary database, the
definition is kept in cache.
# They are specified on a query level with an AS keyword
in an sql statement
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
Explain the term 'database' related to relational database management system?
What is bteq utility in teradata?
How do you set the session mode parameters in bteq?
What is the meaning of Caching in Teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What are the different softwares used with their functions in teradata?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is the purpose of joins in teradata and what are the available join types?
What are the functions of a Parser?
What are the things to be considered while creating secondary index?
What do you mean by fastexport in teradata?
What are the scenarios in which full table scans occurs?
How do you define Teradata?
What is meant by a Least Cost Plan?
Explain how spool space is used.
