How to find duplicates in a table?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More Teradata Interview Questions

Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

0 Answers  


can we join volatile table with general table an global temporary table with general table ?

4 Answers   IBM,


Can any one plz provide the teradata interview questions?

10 Answers  


What are the multiload utility limitations?

0 Answers  


How can we check the version of Teradata that we are using currently?

0 Answers  






What is Difference b/w PI & PPI?how to implement PPI?

3 Answers   Wipro,


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

0 Answers  


Hash collision?

3 Answers   Satyam,


Can you load multiple data files for same target table using fastload?

1 Answers  


i have a table like sales....the field are Prodid Jan(jam month sales)Feb March apr may jun july 1 20 76 50 74 94 93 83 2 30 94 40 94 93 93 02 3 40 90 30 49 94 92 56 4 70 20 30 93 46 35 78 5 23 40 40 39 84 46 57 6 85 30 55 93 46 46 46 7 84 20 65 83 56 57 57 8 10 93 40 93 68 57 36 9 57 30 30 83 67 57 79 10 38 83 40 83 55 68 47 11 35 39 90 94 57 78 47 12 83 89 50 93 79 69 69 i wat ti find the max sales of every product which i want to load into target table

6 Answers   Satyam,


hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com

0 Answers   IBM,


Please tell me a query to find the Primary key,Foreign key,primary Index,PPI for the Database?

5 Answers  


Categories