How do you Generate Sequence in Teradata?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What do you mean by tpt in teradata?

592


What's the difference between timestamp (0) and timestamp (6)?

640


What do you mean by ttu in teradata?

571


Difference between stored procedure and macro?

689


How can you track login parameters of users in teradata?

633






How to view every column and the columns contained in indexes in teradata?

588


A certain load is being imposed on the table and that too, every hour. The traffic in the morning is relatively low, and that of the night is very high. As per this situation, which is the most advisable utility and how is that utility supposed to be loaded?

688


Explain the types of join supports by teradata?

587


Highlight the points of differences between the database and user in Teradata.

590


What is logical data model?

644


Which is more efficient group by or distinct to find duplicates?

646


What is the use of fallback?

560


What are the things to be considered while creating secondary index?

633


if collect stats but it show low confidence why?

1190


What is teradata? What are some primary characteristics of teradata?

547