Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate Sequence in Teradata?
- 3 Answers
- 16310 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 |
Explain the term 'tables' related to relational database management system?
what is use of fload loading into set table?
What are some commonly used bteq scripts?
In your project what type of issues and errors you facing in Teradata
hi frnds i want to learn teradata utilities and teradata dba real time. i have 1+ years of experience in teradata. so i want to go deeply in Tearada. plz let me know at my email id who r best to learn from. im lookng for a realtime guy in HYD or Banglr. Thanks in advance. Rajesh my email-id: rajeshmss87@gmail.com
can we have an unconnected lkp to lookup a DB2 record against a Teradata record?
Syntax for case when statement?
Why is the case expression used in teradata?
What is the purpose of using case expression in teradata?
what is the advantages of other etl tool than teradata utilities or vice versa ?(datastage/informatica)
What is the use of having index on table?
How to improve the query performance without taking the collect statistics? In explain plan i have 'NO CONFIDENT'.
Teradata 
