Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate Sequence in Teradata?
- 3 Answers
- 16163 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 is Join Index in TD and How it works?
Explain the term 'primary key' related to relational database management system?
Explain about Skew Factor?
write lock is compatiable with which type of lock?
Is multi insert ansi standard?
Highlight the differences between Primary Key and Primary Index.
what is object level locking ? where do appear this type of locking ?
Discuss the advantages of using partitioned primary index in a query?
What is the difference between correlated sub queries and inner queries?
how to improve the query perfoemance in teradata.with example?and how explain this in interview?please forward answer
Difference between multiload and tpump?
Steps to create a data model?
Teradata 
