Interested to Buy Any Domain ? << Click Here >> for more details...
Can we take collect stats on Dervied Tables and Volitable
tables,
What is Golabal Temporary table what is the use of this
Golabal Temporary table ,When we create any kind table in
Teradata it will show in Golabal Temporary table
- 6 Answers
- 21339 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / yuvaevergreen
No for volatile and derived tables and yes for golobal
tables. Global tables are temp tables like volatile tables
but unlike volatile tables, their definitions are retained
in dd. It is used whenever there is a need for a temporary
table with same table definition for all users.
| Is This Answer Correct ? | 7 Yes | 5 No |
Post New Answer View All Answers
What are the newly developed features of Teradata?
What is multi insert?
What are the multiload utility limitations?
Why do you get spool space errors? How do trouble-shoot them?
How will you solve the problem that occurs during update?
What is the difference between fastload and multiload? Which one is faster?
What is the function of parser component in teradata?
Why is the case expression used in teradata?
What is the use of stored procedures in teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What are the frequently used data types in teradata?
Explain vproc in teradata?
Can you connect multiload from ab initio?
What is collect statistics?
What is the use of fallback?
