what is identity columns in teradata

Answer Posted / yogi

Identity column is used in tables to get the unique
values.Values of the attribute is stored in DBC.idcol. If
ALWAYS and NO CYCLE option is used, then duplicate values
would be avoided.

Is This Answer Correct ?    3 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is meant by a Parsing Engine?

967


Explain the types of join supports by teradata?

797


During the Display time, how is the sequence generated by Teradata?

832


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

787


Explain the new features of teradata?

822


What is the purpose of upsert command?

837


What is meant by a Clique?

834


What is teradata?

870


Mention the procedure via which, we can run Teradata jobs in a UNIX environment.

799


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

759


Steps to create a data model?

895


What can be achieved by using the teradata rdbms?

839


Why managing the data is important?

795


Can any one explain me the difference between BTEQ and MLOAD,TUMP. All canbe used for same purpose but still differnt methods. why ?

3312


What is meant by a Channel Driver?

899