Interested to Buy Any Domain ? << Click Here >> for more details...
can we join volatile table with general table an global
temporary table with general table
?
- 4 Answers
- 10192 Views
- IBM, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
yes we can join volatile to general table;
>> first we create volatile table
syntax:
create volatile table vt1(x int,y int)on commit preserve rows;
>> we can create general table
syntax:
create table t1(x int,y int,z int);
>>now we can join volatile table and general table
Eg:
select a.x,b.x from vt1 a,t1 b where a.x=b.x;
| Is This Answer Correct ? | 0 Yes | 0 No |
Answer / 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 |
What are the various indexes in teradata? How to use them? Why are they preferred?
What are the uses of client software involved in teradata?
What do you mean by caching in teradata?
How to run the Teradata jobs in unix environment ???
What do you mean by teradata intelliflex?
in a BTEQ we have 2 insert 2 del 2 update statment. when the BTEQ is restarted i need to run the BTEQ from after DEL statment(means no need to run the insert & del stat).what is the logic for the above requirement?
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 do high confidence, low confidence and no confidence mean in explain plan?
if a error occured in FASTLOAD is the fastload job stops?
How many types of index are present in teradata?
Highlight a few of the important components of Teradata?
What is upsert statement in teradata?
Teradata 
