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 are the updated features of teradata?

585


How to Extract data from multiple legacy systems?

576


What are the steps involved after the disk manager passes the request?

582


What are aggregate tables? How do you design them using teradata?

638


In the Primary Index, what is the score of AMPs that are actively involved?

580






Difference between multiload and tpump?

623


How is MLOAD Client System restarted after execution?

604


When tpump is used instead of multiload?

632


What is the purpose of joins in teradata and what are the available join types?

549


What are some primary characteristics of teradata?

552


List out teradata data types?

561


In BTEQ, how are the session-mode parameters being set?

657


How do you determine the number of sessions?

616


What is a dimension table?

610


What is multi insert?

628