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
- 21059 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 is meant by a Clique?
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?
What do high confidence, low confidence and no confidence mean in explain plan?
What is the purpose of joins in teradata and what are the available join types?
How many sessions of MAX is PE capable of handling at a particular time?
What are the different methods ot loading a dimension table? A fact table etc?
What is the maximum number of dml can be coded in a multiload script?
how many modules are there in telecome domain?how to explain the architecture?
In Teradata, how do we Generate Sequence?
What are the commands to make a new table, change a table and remove a table in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What are tpump utility limitations?
What is multi insert?
What is the use of virtual processor connectivity in teradata?
What is the use of teradata system software?
