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
- 16504 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 to Extract data from multiple legacy systems?
Why is the case expression used in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What is dimensional modeling?
Define views in teradata with syntax.
When tpump is used instead of multiload?
What do you mean by teradata intellicloud?
What do high confidence, low confidence and no confidence mean in explain plan?
List the logical and conditional operators that are used with teradata along with their meanings?
Highlight a few of the advantages that ETL tools have over Teradata.
What are the different design perspectives used in teradata?
What is upsert statement in teradata?
Explain how spool space is used.
What is bteq script in teradata?
What are the steps involved after the disk manager passes the request?
