Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate Sequence in Teradata?
- 3 Answers
- 15994 Views
- TCS, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / vinay
By Using Identity Column.
/*I am Teradata working professional and Faculty with 7+
yrs of exp posting for knowledge transfer to students.You
can reach me on teradatavinay@yahoo.com if more
clarification needed./*
| Is This Answer Correct ? | 14 Yes | 4 No |
Answer / kk
1-for storing purpose using identity
2-for display purpose using csum
| Is This Answer Correct ? | 8 Yes | 6 No |
Answer / sridhar
using identity we can generate sequence
syntax:
generated always/by default as identity (start with <value> increment by <value> min<value> max<value> no cycle)..
| Is This Answer Correct ? | 0 Yes | 1 No |
What do you mean by fastexport in teradata?
How would you load a very large file in teradata in general? What utility would you use for it? Why?
Can we collect statistics on multiple columns?
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What interface is used to connect to windows based applications?
What exactly do you know about catching in teradata?
Is it necessary to add? Quit statement after a bteq query when I am calling it in a unix environment?
Explain the term 'foreign key' related to relational database management system?
What does Amp contain and what are all the operations that it performs?
Why do Hash joins usually perform better than Merge Joins?
What is a node in teradata?
If RDBMS is halted what will you do ?
Teradata 
