What are the types of tables in Teradata

Answer Posted / terad

Types of Tables in Teradata :

1.Derived
2.Volatile
3.Global Temp.
4.Permanent
4.1. SET
4.2. Multiset

Is This Answer Correct ?    61 Yes 1 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different functions performed in development phase?

572


Highlight the limitations of TPUMP Utility.

605


What is the purpose of using case expression in teradata?

574


Highlight the points of differences between the database and user in Teradata.

589


Explain some differences between mpp and smp?

592






How is the teradata different from oracle?

626


Which is more efficient group by or distinct to find duplicates?

646


Explain and compare pros and cons of start schemas?

545


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


Explain fastload in teradata?

601


Highlight a few of the important components of Teradata?

584


How would you load a very large file in teradata in general?

565


Explain the term 'columns' related to relational database management system?

548


Explain and compare pros and cons of snow flake schemas?

611


how many modules are there in telecome domain?how to explain the architecture?

1557