What are the types of tables in Teradata
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
Which is more efficient group by or distinct to find duplicates?
What is the difference between teradata and oracle?
What is multi insert?
What are the enhanced features in teradata v2r5 and v2r6?
What are the different functions included in the server software?
What is teradata? What are some primary characteristics of teradata?
What are the different methods ot loading a dimension table? A fact table etc?
What is meant by Teradata Gateway?
What is the use of virtual processor connectivity in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Difference between multiload and tpump?
How to select first n records in teradata?
What are default access rights in teradata? What explicit right can be given to a user?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
What is the meaning of Caching in Teradata?