In general, how do you optimze any sql in teradata?


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

Post New Answer

More Teradata Interview Questions

Explain about Skew Factor?

6 Answers   TCS,


What are the main components of teradata system?

0 Answers  


What does Amp contain and what are all the operations that it performs?

0 Answers  


what do you mean by INMOD Routines and OUTMODE Routines ?

3 Answers  


Different phases of multiload?

0 Answers  






What is the difference between fastload and multiload?

0 Answers  


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

8 Answers   Satyam,


how can i answer for question like teradat architecture in interveiw

4 Answers   TCS,


Find 2 highest sal from each dept who have completed 5 year in org

0 Answers   Wipro,


What is oltp?

0 Answers  


Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq

3 Answers   Wipro,


What is stored procedure in teradata?

0 Answers  


Categories