How do you Generate sequence at the time of Display?
Answer Posted / yuvaevergreen
select csum(1,columnname) will give you the sequence with the mentioned column arranged in ascending order.
Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
How to load specific no.of records using bteq, or fastload,or multiload
What are the various etl tools in the market?
Explain fallback in teradata?
Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?
Explain the meaning of Amp?
During the Display time, how is the sequence generated by Teradata?
What is spool space and when running a job if it reaches the maximum spool space how you solve the problem?
Highlight a few of the important components of Teradata?
Write a program to show the parser component used in teradata?
How will you solve the problem that occurs during update?
What are the scenarios in which full table scans occurs?
If a Node is busy what are the steps you can take to avoid ?
Name the five phases that come under MultiLoad Utility.
Briefly explain each of the following terms related to relational database management system (rdbms) – database, tables, columns, row, primary key and foreign key.
What is the use of stored procedures in teradata?