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 is teradata and why it is used?

577


How teradata makes sure that there are no duplicate rows being inserted when its a set table?

551


Comment whether bottleneck is an error or not.

612


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

567


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1493






Explain the new features of teradata?

557


What are the commands to make a new table, change a table and remove a table in teradata?

603


how do you manage the production space. what are the proactive methods you can take ?

1469


Syntax for case when statement?

600


What is the difference between union and union all in teradata?

609


What are differences between teradata and ansi session modes in teradata?

615


What is the function of parser component in teradata?

613


What is the meaning of Caching in Teradata?

684


What are the multiload utility limitations?

586


How would you load a very large file in teradata in general? What utility would you use for it? Why?

587