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 9159How 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 9163Suppose 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 6463How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 12674what 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 9961
Explain and compare pros and cons of start schemas?
What is a three-tier data warehouse?
Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
How to identify ppi columns?
Which is more efficient group by or distinct to find duplicates?
What's the difference between timestamp (0) and timestamp (6)?
What is inner join and outer join?
In general, how do you optimze any sql in teradata?
How can we check the version of Teradata that we are using currently?
How to load specific no.of records using bteq, or fastload,or multiload
What is meant by a Clique?
How is MLOAD Teradata Server restarted after execution?
What happens in a conflict? How do you handle that?
What are the 5 phases in a multiload utility?