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
Highlight the limitations of TPUMP Utility.
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
What are the string manipulation operators and functions associated with teradata?
How does hashing happens in teradata?
How is MLOAD Teradata Server restarted after execution?
Why are oltp database designs not generally a good idea for a data warehouse?
Define views in teradata with syntax.
What is primary index and secondary index?
What are the functions of a teradata dba?
What are the joins in teradata and how many types of joins are there in teradata?
What happens in a conflict? How do you handle that?
What do you mean by parsing?
What is the purpose of joins in teradata and what are the available join types?
What do you mean by caching in teradata?
What are the updated features of teradata?