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

What do you mean by tpt in teradata?

798


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

855


How to find duplicates in a table?

903


What are the different softwares used with their functions in teradata?

805


What is the use of virtual processor connectivity in teradata?

802


Mention a few of the ETL tools that come under Teradata.

876


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

839


What can be achieved by using the teradata rdbms?

831


What are the components provided on node?

837


What are the newly developed features of Teradata?

804


What are teradata utilities?

858


What are the steps involved after the disk manager passes the request?

829


In the Primary Index, what is the score of AMPs that are actively involved?

803


Explain BYNET.

800


What is the difference between fastload and multiload? Which one is faster?

907