Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  1. Categories >> Software >> Data Warehouse >> Teradata
  2. Suggest New Category

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

Question Posted / kk

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

What are types of partition primary index (ppi) in teradata?

0 Answers  

Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE

2 Answers   IBM,

What do you mean by fastexport in teradata?

0 Answers  

How do you eliminate duplicates?

3 Answers  

Can we load a Multi set table using MLOAD?

2 Answers  

Hello all, There is a table with 4 columns in that 3 columns has been already loaded with 5 million records.4th column is empty,Now I have got 5 million records data which has to be loaded into 4th column.How can I load this data fastly in to the 4th column with out using update

5 Answers   CTS, TCS,

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

3 Answers   TCS,

What are the functions of a Parser?

0 Answers  

Syntax for case when statement?

0 Answers  

What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,

hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. yedu my email-id: jakkayedukondalu@gmail.com@gmail.com

0 Answers  

During the Display time, how is the sequence generated by Teradata?

0 Answers  

For more Teradata Interview Questions Click Here
Categories