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
- 16574 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / tdguy
Sometimes, we may need aggregated data using some no of
columns from a very big table and these results are needed
in multiple sql requests In those cases, temporary tables
come in to picture and hold these temporary results for
further processing. When you need the table to be used
across sessions, GTT would be used so that definition would
be retained and can be reused by multiple users. When there
is a need only within the session, volatile table would be
used. These tables also help in speedy running of sqls.
| Is This Answer Correct ? | 10 Yes | 0 No |
Answer / 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 |
In BTEQ, how are the session-mode parameters being set?
What are the updated features of teradata?
What is a node in teradata?
What are the available primary index types in teradata.
Increasing no of amps will increase performance. Is this true?
What are the 5 phases in a multiload utility?
Hi Friends I have a sql question, We have the source data as below. 101 address1, address2, address3 and the output shoulb like below 101 address1 101 address2 101 address3 Required a SQL query for this output. Please let me know if you have any sql query for this. Thanks in advance. Hari M
What are the frequently used data types in teradata?
We are migrating an oracle table into teradata, the volume of data is huge and partitioned (year wise list partition). How do i simulate the same in teradata.
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?
What is Difference b/w PI & PPI?how to implement PPI?
What is Join Index in TD and How it works?
Teradata 
