can we join volatile table with general table an global
temporary table with general table
?
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 |
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Which is faster fastload or multiload?
What is collect State in Teradata ? what it use and how it works??
Describe the between keyword in teradata?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
In which scenarios we use Volatile tables and Global temporary Tables in Real time? Please give me one real time scenario???I know wat is its use??
Difference between inner join and outer join?
Difference between Qualify and group
What is a three-tier data warehouse?
What is a node in teradata? Explain
In the Primary Index, what is the score of AMPs that are actively involved?
what is use of PI(primary index) AND SI(secondary index)