Interested to Buy Any Domain ? << Click Here >> for more details...
What are the types of tables in Teradata
- 22 Answers
- 79283 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 types of partition primary index (ppi) in teradata?
Why do you get spool space errors? How do trouble-shoot them?
Explain the term 'row' related to relational database management system?
Highlight a few of the advantages that ETL tools have over Teradata.
Explain the teradata primary index mechanics in detail with a diagram.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
why use references rather than pointers in the public api, particularly for arguments which are modified?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
During the Display time, how is the sequence generated by Teradata?
What is a sparse index?
what are the day to day activities of teradata DBA ?
What are normalization, first normal form, second normal form and third normal form?
Explain the advantages of partitioned primary index in a query?
Explain and compare pros and cons of snow flake schemas?
How is MLOAD Teradata Server restarted after execution?
