How do you Generate Sequence in Teradata?
- 3 Answers
- 15203 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 |
Syntax for case when statement?
Highlight a few of the advantages that ETL tools have over Teradata.
plz explain parlla distribution and subtable concept in teradata
What is a sparse index?
Hi All, I have a table with 3 fields like id,mark1,mark2 and I would like to update a mark3 field that would calculate the max for each record (so the max value of the 2 fields) in Teradata ID Mark1 Mark2 Mark3 1 10 20 2 20 30 3 40 10 4 50 50 I Have to write a update statement Mark3 with max value of mark1,mark2 fields…like bellow ID Mark1 Mark2 Mark3 1 10 20 20 2 20 30 30 3 40 10 40 4 50 50 50 Please any one help me ....Thq
Explain Teradata performance tuning and optimization?
What is Join Index in TD and How it works?
Can you load multiple data files for same target table using fastload?
Can you fastexport a field, which is primary key by putting equality on that key?
What is real time and near real time data warehousing?
What tools would you use for that?
What are the 5 phases in a multiload utility?
Teradata 
