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
Explain the types of join supports by teradata?
How to load specific no.of records using bteq, or fastload,or multiload
What is the maximum number of dml can be coded in a multiload script?
any one answer me how they can analyzing the project using data ware housing?
What are the advantages of teradata?
What are the components provided on node?
What is primary index and secondary index?
Discuss the advantages of using partitioned primary index in a query?
What is the syntax for case when statement?
What exactly do you know about catching in teradata?
What happens when a node suffers a downfall?
How to view every column and the columns contained in indexes in teradata?
How is MLOAD Teradata Server restarted after execution?
Explain teradata vs. Redshift?
Explain parsing engine in teradata?