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
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 the purpose of joins in teradata and what are the available join types?
What is collect statistics?
How to write the query . eid enm doj dob i want to display the names who worked more than 25 years .
Mention a few of the ETL tools that come under Teradata.
What exactly do you know about catching in teradata?
Which is more efficient group by or distinct to find duplicates?
What is teradata?
What are the 5 phases in a multiload utility?
What are teradata utilities?
If RDBMS is halted what will you do ?
What are types of partition primary index (ppi) in teradata?
What happens in a conflict? How do you handle that?
What is bteq script in teradata?
Difference between stored procedure and macro?
What is a three-tier data warehouse?