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
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to load specific no.of records using bteq, or fastload,or multiload
Describe the set operators in teradata.
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by a dispatcher?
How do you verify a complicated sql?
Explain vproc in teradata?
Explain the most common data types used in teradata?
What is teradata? Also, list out some of the primary characteristics of teradata.
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.
Explain teradata architecture in detail with a diagram.
When tpump is used instead of multiload?
What are normalization, first normal form, second normal form and third normal form?