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 |
Highlight the points of differences between the database and user in Teradata.
Explain the term 'columns' related to relational database management system?
wt r before journal& after journel.....in teradata
Give the sizes of SMALLINT, BYTEINT and INTEGER.
Highlight a few of the advantages that ETL tools have over Teradata.
What is oltp?
what is the query for retrieve the unique values(not display the duplicates values) from single table?
Where is teradata rdbms used?
Can any one plz provide the teradata interview questions?
Explain the term 'row' related to relational database management system?
On which column will you take primary index???
What are the different functions included in the server software?