Interested to Buy Any Domain ? << Click Here >> for more details...
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 10417How 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 10055Suppose 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 7786How do you check the performance of Teradata Query and list down the basic Performance Tuning steps you use?
IBM,
2 13665what 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 11602
What are the different methods ot loading a dimension table? A fact table etc?
Explain vproc in teradata?
Did you write stored procedures in teradata?
Explain the advantages of partitioned primary index in a query?
What is the difference between union and union all in teradata?
How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.
What do high confidence, low confidence and no confidence mean in explain plan?
Why do you get spool space errors? How do trouble-shoot them?
How do you set the session mode parameters in bteq?
Explain the parallel data extension in teradata?
why use references rather than pointers in the public api, particularly for arguments which are modified?
What is the purpose of joins in teradata and what are the available join types?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
Syntax for case when statement?
How can bottlenecks be identified?
