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

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

586


Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com

1946


What are the various indexes in teradata? How to use them?

546


During the Display time, how is the sequence generated by Teradata?

605


What is TPD?

892






What are the various etl tools in the market?

566


What are the various reporting tools in the market?

600


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

585


What are the functions involved in shared information architecture?

588


Different phases of multiload?

580


How do you determine the number of sessions?

604


What do you mean by teradata intelliflex?

614


What exactly do you know about catching in teradata?

623


What are the updated features of teradata?

567


What is multi insert?

617