What are the types of tables in Teradata

Answer Posted / pandit

Derived Tables: Tables created for subquery. these are
Query specific. Once the query is over they are dropped.

Is This Answer Correct ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

685


Give a justifiable reason why Multi-load supports NUSI instead of USI.

672


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1765


What are the various etl tools in the market?

583


Explain the advantages of partitioned primary index in a query?

562






If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1736


What are the steps to create a data model?

598


What is the command in bteq to check for session settings ?

634


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

596


How does hashing happens in teradata?

619


Explain vproc in teradata?

564


Highlight all the modes that are present under Confidence Level.

537


What is the function of parser component in teradata?

619


What does Amp contain and what are all the operations that it performs?

585


What is difference between user and database in teradata?

616