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
- 21159 Views
- IBM, I also Faced
- E-Mail Answers
Answer Posted / vinay sir,dwh technologies,ame
Small correction guys for the above answers:
We can collect statitics on volatile tables in TEARADATA-13.
Just try at home.
Derived tables any way we can collect.
Volatile tables life time with in the session(Data and
Structure).
Global temporary tables life time accross sessions
(definition only).
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
Difference between stored procedure and macro?
What type of indexing mechanism do we need to use for a typical data warehouse?
Why are oltp database designs not generally a good idea for a data warehouse?
How do you define Teradata?
Explain the term 'columns' related to relational database management system?
What are default access rights in teradata? What explicit right can be given to a user?
What are the different table types that are supported by teradata?
How do you determine the number of sessions?
What is teradata? What are some primary characteristics of teradata?
What is basic teradata query language?
Can we collect statistics on multiple columns?
When tpump is used instead of multiload?
how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
What are the functions performed by bynet?
