What are the uses of bynets in multi-node systems?
which option is used to restart the fastexport script ?
how do you handle ET and UV errors ?
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
What is primary index and secondary index?
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?
How do you design aggregate tables using teradata?
What is the purpose of joins in teradata and what are the available join types?
Hi frnds this question is asked at IBM One query is there when we dont collect stastics on it,exlapin will show us LOW CONFIDENCE,When we collect stastics it shows HIGH CONFIDENCE.WHAT IS THE INTERNAL ARCHITECTURE ACTUALLY GOING ON ?????ASKED ON 23-08-2012 THANKS IN ADVANCE
1.what is activity count? 2.what is skew factor? how it's working explain brefily
What is the difference between union and union all in teradata?
Comment whether bottleneck is an error or not.
What happens in a conflict? How do you handle that?