Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 78677 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
What are the various etl tools in the market?
What is the multi-insert?
What are the various indexes in teradata? How to use them? Why are they preferred?
How many sessions of MAX is PE capable of handling at a particular time?
Why teradata is used?
What are the different functions included in the server software?
What are the string manipulation operators and functions associated with teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
Define views in teradata with syntax.
What is the difference between fastload and multiload?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the different design perspectives used in teradata?
Explain teradata utilities. What is multiload, fast load, tpump?
What is the maximum number of dml can be coded in a multiload script?
