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
- 16440 Views
- CTS, Lexicon, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / 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 |
How is MLOAD Teradata Server restarted after execution?
which utitility can use for loading the data from non-teradata to teradata ?
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the commands to make a new table, change a table and remove a table in teradata?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
Differentiate database data and data warehouse data?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
Give some points about Teradata Viewpoint ?
Explain the advantages of partitioned primary index in a query?
How do you define Teradata?
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Teradata 
