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
What is the purpose of joins in teradata?
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
How is MLOAD Client System restarted after execution?
What is the basic syntax for teradata select statement?
Can you connect multiload from ab initio?
What are normalization, first normal form, second normal form and third normal form?
Describe the between keyword in teradata?
How is MLOAD Teradata Server restarted after execution?
Explain the parallel data extension in teradata?
Mention a few of the ETL tools that come under Teradata.
What is bteq script in teradata?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
In BTEQ, how are the session-mode parameters being set?
Did you write stored procedures in teradata?
Difference between star and snowflake schemas?