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
- 21301 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 upsert statement in teradata?
What is node? How many nodes and amps used in your previous project?
In a table can we use primary key in one column and in another column both unique and not null constrains.if yes how?
What is inner join and outer join?
Why teradata is used?
What are the functions involved in shared information architecture?
What are some primary characteristics of teradata?
What are the different design perspectives used in teradata?
What are the steps involved in the process flow of the sql statement through channel attached system?
Explain some differences between mpp and smp?
Explain the advantages of partitioned primary index in a query?
Which is faster fastload or multiload?
Explain and compare pros and cons of snow flake schemas?
What is spool space? Why do you get spool space errors?
How is the teradata different from oracle?
