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
- 21070 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
tomorrow i have interview in infosys.can someone pour any suggestions or any interview questions. thank you
Explain vproc in teradata?
Describe the set operators in teradata.
What do you mean by teradata sql assistant?
List out teradata data types?
Differentiate database data and data warehouse data?
How to find duplicates in a table?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is meant by a Clique?
How do you create tables? Exact syntax, and create profiles, users in teradata?
What is the use of virtual processor connectivity in teradata?
What are the design features involved in teradata?
Explain the term 'database' related to relational database management system?
How do you set the session mode parameters in bteq?
Mention a few of the ETL tools that come under Teradata.
