Interested to Buy Any Domain ? << Click Here >> for more details...
In which scenarios we use Volatile tables and Global
temporary Tables in Real time? Please give me one real time
scenario???I know wat is its use??
- 3 Answers
- 16556 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
A volatile table is dropped at the end of the session(both
definition and data). It is stored in spool space and
statistics for the data cannot be collected. A global
temporary table's data alone is dropped at the end of the
session. It is stored in temp space and stats can be
collected. Any user can make use of the definition within
his temp space.
| Is This Answer Correct ? | 14 Yes | 6 No |
Post New Answer View All Answers
How can bottlenecks be identified?
What are types of partition primary index (ppi) in teradata?
What is the difference between union and union all in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.
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
How many tables can you join in v2r5?
Explain BYNET.
How do you do backup and recovery in teradata?
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?
What are default access rights in teradata? What explicit right can be given to a user?
What are the various reporting tools in the market?
What is meant by a node?
In the Primary Index, what is the score of AMPs that are actively involved?
What are the various indexes in teradata? Why are they preferred?
What is a dimension table?
