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 10249How 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 9947Suppose 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 7560How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13541what 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 11445
Mention a few of the ETL tools that come under Teradata.
How will you solve the problem that occurs during update?
What is spool space?
What are teradata utilities?
Explain the term 'foreign key' related to relational database management system?
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 view every column and the columns contained in indexes in teradata?
What is the purpose of upsert command?
What are the joins in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Name the five phases that come under MultiLoad Utility.
Difference between multiload and tpump?
Explain the parallel data extension in teradata?
Steps to create a data model?
What is the difference between teradata and oracle?