How many types of joins are there in teradata?
No Answer is Posted For this Question
Be the First to Post Answer
Why Multiload does not supports USI and supports NUSI?
What are aggregate tables? How do you design them using teradata?
Difference between Teradata V2R5 and Teradata V12 versions?
Explain the advantages of partitioned primary index in a query?
How do you Generate Sequence in Teradata?
What are the different functions included in the server software?
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
Give some points about Teradata Viewpoint ?
Let us say there is a file that consists of 100 records out of which we need to skip the first and the last 20 records. What will the code snippet?
What is the purpose of upsert command?
what is identity column in TD?
can I use “drop” statement in the utility “fload”?
2 Answers Accenture, CTS, NTT Data,