Follow Our FB Page << >> 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 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

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