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 |
What is a clique?
what is DYNAMIC SQL in TD?
What is the command in bteq to check for session settings ?
TCS recently asked this question I have records like below Emp id Empname Salary DateTimestamp 1 AA 6000 20120609:11:30 1 AA 7000 20120609:12:30 1 AA 8000 20120609:01:30 I want to exceute records max timestamp(20120609:01:30)
What is meant by a Channel Driver?
Difference between star and snowflake schemas?
What are different table types used in teradata?
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
what are the default access rights in the teradata?
what is the difference between primary index and secondary index?.