1-for storing purpose using identity 2-for display purpose using csum

How do you Generate Sequence in Teradata?

Question Posted / kk

Answer Posted / kk

1-for storing purpose using identity

2-for display purpose using csum

Is This Answer Correct ?

8 Yes

6 No

Please Help Members By Posting Answers For Below Questions

What are the functions involved in shared information architecture?

1033

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

1053

What is teradata?

1072

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

988

How can you track login parameters of users in teradata?

1137

What are tpump utility limitations?

1076

Explain teradata architecture in detail with a diagram.

1059

What are the scenarios in which full table scans occurs?

959

What is the purpose of upsert command?

1098

What are the updated features of teradata?

1003

Discuss the advantages of using partitioned primary index in a query?

918

Explain fallback in teradata?

991

When tpump is used instead of multiload?

1058

What are some commonly used bteq scripts?

950

What is spool space? Why do you get spool space errors?

964