Follow Our FB Page << CircleMedia.in >> for Daily Laughter. We Post Funny, Viral, Comedy Videos, Memes, Vines...


How do you Generate Sequence in Teradata?

Answers were Sorted based on User's Feedback



How do you Generate Sequence in Teradata?..

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

How do you Generate Sequence in Teradata?..

Answer / kk

1-for storing purpose using identity

2-for display purpose using csum

Is This Answer Correct ?    8 Yes 5 No

How do you Generate Sequence in Teradata?..

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

Post New Answer



More Teradata Interview Questions

If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?

0 Answers  


What are the uses of bynets in multi-node systems?

0 Answers  


how do you handle ET and UV errors ?

2 Answers  


What tools would you use for that?

0 Answers  


What is basic teradata query language?

0 Answers  






Difference between stored procedure and macro?

0 Answers  


What type of indexing mechanism do we need to use for a typical data warehouse?

0 Answers  


Hi friends This is suneel and i am new to teradata. In both situvations teradata administrator and teradata sql assitant 12.0 1)How to create database in teradata and under database how to create user. 2)How to create table under that user and giving privilizes to that user. Thanks alot.

1 Answers  


i am pursuing mca and i want to do tera data .so plz suggest me the best institue in hydrabad who teach real tym scenerio.

1 Answers  


Is multi insert ansi standard?

0 Answers  


how do we write scripts in unix how to execute scripts in real time anybody please needfull or give me number i will cal u

0 Answers  


I have a table with emp id, emp name, dept id and sal where dept id is NUSI. SEL * FROM EMP WHERE DEPTID = 100. Can any one explain how it will fetch the record.

4 Answers  






Categories