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
- 16555 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
A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?
Explain teradata vs. Redshift?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What's the difference between timestamp (0) and timestamp (6)?
What is the basic syntax for teradata select statement?
What is called partitioned primary index (ppi)?
What is upsert statement in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
How you will check the version of teradata?
What is real time and near real time data warehousing?
Mention a few of the ETL tools that come under Teradata.
What is the purpose of joins in teradata?
If Fast Load Script fails and only the error tables are made available to you, then how will you restart?
Can you connect multiload from ab initio?
What is the use of fallback?
