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

Define views in teradata with general syntax.

544


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

549


How to load specific no.of records using bteq, or fastload,or multiload

1297


Explain the meaning of Amp?

561


What is the particular designated level at which a LOCK is liable to be applied in Teradata?

575






What is oltp?

547


What is meant by a node?

594


Explain some differences between mpp and smp?

568


How to eliminate product joins in a teradata sql query?

581


Highlight the differences between Primary Key and Primary Index.

590


Give a justifiable reason why Multi-load supports NUSI instead of USI.

650


Highlight a few of the advantages that ETL tools have over Teradata.

586


If Fast Load Script fails and only the error tables are made available to you, then how will you restart?

617


Describe primary index in teradata. And what are the available primary index types?

520


What does sleep function does in fast load?

592