what is identity columns in TD?

Answer Posted / yuvaevergreen

Identity column is a system generated value. Used for row
uniqueness. If rows need to be unique, then ALWAYS option
should be used with NO CYCLE option. Separate DBC table
takes care of identity columns DBC.idcol.

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many codd's rules are satisfied by teradata database?

656


What tools would you use for that?

559


What is the difference between teradata and basic rdbms?

559


What are the different table types that are supported by teradata?

533


What is a level of granularity of a fact table?

637






If the PMON is not working then how do you manage and monitor all processes, resources and sessions etc.

1663


Syntax for case when statement?

601


What is a dimension table?

602


What are the 5 phases in a multiload utility?

601


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

583


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

504


How can you track login parameters of users in teradata?

622


There is a column with date in it. If I want to get just month how it can be done? Can I use sub string?

627


Different phases of multiload?

586


Backup Script was blocked then you are unable to archive the data. how do you analyze it and where do you identify ?

1493