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


Please Help Members By Posting Answers For Below Questions

Highlight the limitations of TPUMP Utility.

800


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

835


What are the string manipulation operators and functions associated with teradata?

845


How does hashing happens in teradata?

840


How is MLOAD Teradata Server restarted after execution?

904


Why are oltp database designs not generally a good idea for a data warehouse?

823


Define views in teradata with syntax.

834


What is primary index and secondary index?

798


What are the functions of a teradata dba?

813


What are the joins in teradata and how many types of joins are there in teradata?

783


What happens in a conflict? How do you handle that?

837


What do you mean by parsing?

830


What is the purpose of joins in teradata and what are the available join types?

776


What do you mean by caching in teradata?

827


What are the updated features of teradata?

802