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
- 10204 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 |
hi guys...i have good experiance in oracle ...now i want to learn teradata? how much of percentage my knowledge is used to understand the teradata? i mean.. if teradata also having sql queries or not?
Hi, If anyone has TD 14 Basics dumps or study materials, please share. nirmaaal1991@gmail.com
Give a justifiable reason why Multi-load supports NUSI instead of USI.
There is a load to the Table every one hour and 24/7.Morning trafic is high, afternoon trafiic is less, Night trafiic is high.According to this situation which Utility you use and how do you load,which utility used?
Explain teradata vs. Redshift?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
What are types of partition primary index (ppi) in teradata?
What is database exceptions in teradata?
What do you mean by parsing?
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?
Explain parsing engine in teradata?
What is the default join strategy in Teradata???
Teradata 
