Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate Sequence in Teradata?
- 3 Answers
- 16183 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 are the various indexes in teradata? Why are they preferred?
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Steps to create a data model?
Why MultiLoad Utility supports only Non Unique Secondary Index(NUSI) in the Target Table ?
What are the various indexes in teradata? How to use them?
Explain the term 'tables' related to relational database management system?
What interface is used to connect to windows based applications?
What do you mean by teradata intelliflex?
"pravalli nagireddy" record is there in address column but i want display only 'nagireddy' from the main string what is query for that pls tell me
Does SDLC changes when you use Teradata instead of Oracle?
What is the meaning of Caching in Teradata?
What do you mean by teradata sql assistant?
Teradata 
