can we join volatile table with general table an global
temporary table with general table
?
Answer Posted / tdguy
yes. its possible. And in TD 14.0, we can collect stats for
volatile tables also. Therefore queries need to be looked
upon for better performance.
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
Explain vproc in teradata?
What do you mean by caching in teradata?
Can we have two time dimensions in a schema(either star or snow flake)? For ex if we want joining date of employee and if we want today's sales with time whether can we have two time dimensions for accommodating above tasks?
What is the purpose of using case expression in teradata?
Give a justifiable reason why Multi-load supports NUSI instead of USI.
Explain the term 'foreign key' related to relational database management system?
What is the meaning of Caching in Teradata?
Which is more efficient group by or distinct to find duplicates?
What are some primary characteristics of teradata?
In Teradata, what is the significance of UPSERT command?
What are default access rights in teradata?
Describe the set operators in teradata.
How to eliminate product joins in a teradata sql query?
Describe the between keyword in teradata?
Mention the procedure via which, we can run Teradata jobs in a UNIX environment.