Interested to Buy Any Domain ? << Click Here >> for more details...
How do you Generate Sequence in Teradata?
- 3 Answers
- 16178 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 |
Backup Script was blocked you are unable to archive the data now. how do you analyze it and where do you identify ?
Highlight the points of differences between the database and user in Teradata.
How teradata makes sure that there are no duplicate rows being inserted when its a set table?
How do you eliminate duplicates?
Define views in teradata with general syntax.
how to delete duplicate records in multi set table without using any tables
2 Answers Accenture, Nest, South Nests Software Solution, Spiro Solutions,
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
What is the purpose of using case expression in teradata?
Where we use PPI in real time??? What is the disadvantages of PPI?
id name gender 1 Ram Female 2 Kumar Female 3 sathish Female 4 Santhya Male 5 Durga Male 6 Priya Male This is my input...how to change Gender Male to Female & Female to Male??? Write sql query for this question???
How will you solve the problem that occurs during update?
IN A TABLE CAN WE USE PRIMARY KEY IN ONE COLUMN AND IN ANOTHER COLUMN BOTH UNIQUE AND NOT NULL CONSTRAINS.IF YES HOW?PLZ GIVE ME A EXAMPLE.
Teradata 
