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?
CTS,
3 10403How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
1 10047Suppose i have data like 2009/12/31 555555534 ' ' Generally last 2 records are wrong format it is going to error table but i don't want load error table if any wrong format in Date column Pass "NULL" how can we do it fast load
4 7767How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13659what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?
HCL,
3 11583
What is a sparse index?
Highlight the points of differences between the database and user in Teradata.
My table got locked during mload due to a failed job. What do I do to perform other operations on it?
Difference between star and snowflake schemas?
Explain the term 'database' related to relational database management system?
How will you solve the problem that occurs during update?
What are the components provided on node?
What are the things to be considered while creating secondary index?
What is teradata?
What is multi insert?
What is stored procedure in teradata?
What do you mean by teradata sql assistant?
Define views in teradata with syntax.
what is object level locking ? where do appear this type of locking ?
Which is faster fastload or multiload?