What are the types of tables in Teradata
Answer Posted / rd
1-- SET TABLE
2-- MULTISET TABLE
3-- PERMANANT TABLE
4-- GLOBAL TEMPORARY TABLE(TEMPORARY TABLE)
5-- VOLATILE TABLE
6-- DERIVED TABLE
| Is This Answer Correct ? | 9 Yes | 9 No |
Post New Answer View All Answers
What is spool space?
What is meant by a Parsing Engine?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
What are differences between teradata and ansi session modes in teradata?
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
What is the basic syntax for teradata select statement?
what is sysdba and sysdbc ? which has high priority ?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Can we collect statistics on table level?
What are default access rights in teradata? What explicit right can be given to a user?
What are the enhanced features in teradata v2r5 and v2r6?
In general, how do you optimze any sql in teradata?
Explain how spool space is used.
What is the multi-insert?
How do you see a ddl for an existing table?