Which is more efficient group by or distinct to find duplicates?
No Answer is Posted For this Question
Be the First to Post Answer
How to load specific no.of records using bteq, or fastload,or multiload
Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A
What is the default join strategy in Teradata???
what do you mean by INMOD Routines and OUTMODE Routines ?
what is differences between Fastload and Multiload as per DBA aspect ?
What is meant by a dispatcher?
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
What is the diffrence between Multiload & Fastload interms of Performance?
I have a employee table with EMPID, EMPNAME, DEPTID, SAL and want to fetch the maximum and minimum salary on each dept id with the emp name. Can anyone help in this? The result should contain the EMPNAME, DEPTID, SAL.
i have a table like sales....the field are Prodid Jan(jam month sales)Feb March 1 20 76 50 2 30 94 40 3 40 90 30 4 70 20 30 5 23 40 40 6 85 30 55 7 84 20 65 8 10 93 40 9 57 30 30 10 38 83 40 11 35 39 90 12 83 89 50 Now the Question is i want get the max sales of 12 products from the months.hint:for eg I WANT GET 89 for product12... Can any one help me
Can we load a Multi set table using MLOAD?
Explain fallback in teradata?