How do you Generate Sequence in Teradata?
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 |
Difference between client character set and server character set? What is the use of these two?default character set in teradata?
What does Amp contain and what are all the operations that it performs?
While creating table my dba has fallback or no fallback in his ddl. What is that?
List the logical and conditional operators that are used with teradata along with their meanings?
What are aggregate tables? How do you design them using teradata?
What is primary index and secondary index?
How do you set the session mode parameters in bteq?
What are the newly developed features of Teradata?
Does anyone got Latest TERADATA V12 Certification Dumps for the below? TE0-121 , TE0-122 , TE0-123 , TE0-124 , TE0-125 , TE0-126 TE0-127 , TE0-12Q
how can i answer for question like teradat architecture in interveiw
What is the difference between fastload and multiload?
How do you define Teradata?