How do you Generate Sequence in Teradata?

Answer Posted / kk

1-for storing purpose using identity

2-for display purpose using csum

Is This Answer Correct ?    8 Yes 6 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the teradata primary index mechanics in detail with a diagram.

762


How do you verify a complicated sql?

849


Explain fallback in teradata?

808


Describe primary index in teradata?

785


What is called partitioned primary index (ppi) and discuss the advantages of using it in a query?

784


Difference between multiload and tpump?

855


what are the uses of fact table and dimension table in banking project?

4330


Describe the set operators in teradata.

781


Explain the term 'row' related to relational database management system?

738


What is the syntax for case when statement?

825


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

817


How can bottlenecks be identified?

777


What are the various indexes in teradata? How to use them?

776


How does hashing happens in teradata?

848


why use references rather than pointers in the public api, particularly for arguments which are modified?

778