Syntax for case when statement?
Why do you get spool space errors? How do trouble-shoot them?
plz explain parlla distribution and subtable concept in teradata
how do you handle ET and UV errors ?
What are the uses of bynets in multi-node systems?
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?
What is meant by a Clique?
What are types of partition primary index (ppi) in teradata?
Explain how spool space is used.
What is collect statistics?
Write a program to show the parser component used in teradata?
How to handle nulls in Teradata??? How many columns can be there in a table??? How to find average sal with out using avg function????
what is a multi statement request in TD? what is the diif b/w V2R5 & TD12? what is the diff b/w MACRO & STORED PROCEDURE?