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
- 21161 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
How do you determine the number of sessions?
What are teradata utilities?
What is collect statistics?
How will you solve the problem that occurs during update?
What is called partitioned primary index (ppi)?
What are the components provided on node?
Different phases of multiload?
What are the multiload utility limitations?
What is difference between user and database in teradata?
What is partitioned primary index (ppi)?
What is meant by Teradata Gateway?
What are the available join types in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Highlight all the modes that are present under Confidence Level.
