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
- 16392 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 functions performed by bynet?
Difference between inner join and outer join?
What are the frequently used data types in teradata?
What is dimensional modeling?
What are default access rights in teradata?
What is teradata? What are some primary characteristics of teradata?
Why does varchar occupy 2 extra bytes?
What is spool space? Why do you get spool space errors? How do trouble-shoot them?
How to eliminate product joins in a teradata sql query?
Define views in teradata with syntax.
How to load specific no.of records using bteq, or fastload,or multiload
What is the difference between fastload and multiload? Which one is faster?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Explain amp in teradata?
Difference between stored procedure and macro?
