What is spool space? Why do you get spool space errors? How do trouble-shoot them?
No Answer is Posted For this Question
Be the First to Post Answer
How to eliminate product joins in a teradata sql query?
Explain the advantages of partitioned primary index in a query?
How can bottlenecks be identified?
What are the various indexes in teradata? How to use them? Why are they preferred?
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 are the 5 phases in a multiload utility?
What is upsert statement in teradata?
what is use of PI(primary index) AND SI(secondary index)
Explain the term 'columns' related to relational database management system?
How will you solve the problem that occurs during update?
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
What is teradata and why it is used?