can we join volatile table with general table an global
temporary table with general table
?

Answers were Sorted based on User's Feedback



can we join volatile table with general table an global temporary table with general table ?..

Answer / nitin bansal

yes we can

Is This Answer Correct ?    1 Yes 0 No

can we join volatile table with general table an global temporary table with general table ?..

Answer / sri

can u pls give the syntax.....

Is This Answer Correct ?    0 Yes 0 No

can we join volatile table with general table an global temporary table with general table ?..

Answer / rkraju

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

can we join volatile table with general table an global temporary table with general table ?..

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

Post New Answer

More Teradata Interview Questions

Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

0 Answers  


Which is faster fastload or multiload?

0 Answers  


What is collect State in Teradata ? what it use and how it works??

3 Answers   TCS,


Describe the between keyword in teradata?

0 Answers  


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)

2 Answers   TCS,






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??

3 Answers   CTS, Lexicon,


Difference between inner join and outer join?

0 Answers  


Difference between Qualify and group

4 Answers   CTS,


What is a three-tier data warehouse?

0 Answers  


What is a node in teradata? Explain

0 Answers  


In the Primary Index, what is the score of AMPs that are actively involved?

0 Answers  


what is use of PI(primary index) AND SI(secondary index)

2 Answers   Wipro,


Categories