What are the types of tables in Teradata
Answer Posted / arun reddy
1.PERMANENT TABLE
2.INTERM TABLE
3.SET TABLE
4.MULTISET TABLE
5.VOLATILE TABLE
6.GLOBAL TEMPORARY TABLE
7.DERIVED TABLE
| Is This Answer Correct ? | 3 Yes | 2 No |
Post New Answer View All Answers
Define views in teradata with syntax.
Syntax for case when statement?
What are differences between teradata and ansi session modes in teradata?
What is the basic syntax for teradata select statement?
How to view every column and the columns contained in indexes in teradata?
What are the various indexes in teradata? Why are they preferred?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What happens when a node suffers a downfall?
What is the difference between union and union all in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
Explain teradata architecture in detail with a diagram.
In Teradata, what is the significance of UPSERT command?
How do you create tables? Exact syntax, and create profiles, users in teradata?
Can we collect statistics on multiple columns?
What are the different functions performed in development phase?