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
- 15174 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 is inner join and outer join?
Explain teradata architecture?
Describe primary index in teradata?
How will you solve the problem that occurs during update?
Explain PDE.
How do you determine the number of sessions?
Difference between stored procedure and macro?
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
What is spool space?
What is node? How many nodes and amps used in your previous project?
Why managing the data is important?
Difference between multiload and tpump?
What are the advantages of teradata?
Difference between star and snowflake schemas?
Explain amp in teradata?
