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
- 21553 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
In the Primary Index, what is the score of AMPs that are actively involved?
Why managing the data is important?
What are the steps involved in the process flow of the sql statement through channel attached system?
What is the purpose of upsert command?
What are the different functions performed in development phase?
What is the purpose of joins in teradata?
What do you mean by ttu in teradata?
What is meant by Teradata Gateway?
How to eliminate product joins in a teradata sql query?
What do you mean by teradata intellicloud?
What is a three-tier data warehouse?
What are teradata utilities?
What is the difference between fastload and multiload? Which one is faster?
What is inner join and outer join?
Why teradata is used?
