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
- 16713 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
What are the different softwares used with their functions in teradata?
Can you fastexport a field, which is primary key by putting equality on that key?
What are the primary characteristics of the Teradata.
What is the particular designated level at which a LOCK is liable to be applied in Teradata?
What are the various indexes in teradata? How to use them?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
What are the steps involved in the process flow of the sql statement through channel attached system?
Can we collect statistics on multiple columns?
What are default access rights in teradata? What explicit right can be given to a user?
What are tpump utility limitations?
How many tables can you join in v2r5?
What is teradata? What are some primary characteristics of teradata?
What is the purpose of upsert command?
Highlight the limitations of TPUMP Utility.
How to find duplicates in a table?
