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
- 19620 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 spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Why teradata is used?
What are the functions of a Parser?
What is logical data model?
Difference between stored procedure and macro?
What exactly do you know about catching in teradata?
What are the different design perspectives used in teradata?
What is the maximum number of dml can be coded in a multiload script?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
What is meant by Teradata Gateway?
What is bteq utility in teradata?
What are the available primary index types?
What do you mean by teradata intelliflex?
What is meant by a Highest Cost Plan?
What are the steps to create a data model?
