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
- 10132 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 |
Highlight a few of the advantages that ETL tools have over Teradata.
where we can use the delimiter in mload? pls let me know
What is basic teradata query language?
sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id where b.deptno=10; sel a.t1,b.t1 from emp a left outer join dept b ON a.id=b.id and b.deptno=10; what is the difference on the above 2 queries?
What is node? How many nodes and amps used in your previous project?
What are the updated features of teradata?
Explain the parallel data extension in teradata?
How do you do backup and recovery in teradata?
i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com
teradata support to automatically increase the character length or not?
What are normalization, first normal form, second normal form and third normal form?
What is a sparse index?
Teradata 
