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

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

1737


What are the available join types in teradata?

835


What is oltp?

778


i learn teradata,it is so intersting,now i want teradata certifications ,so any 1 help me to get teradata certifications TD 12 ? email:kdcrazyy@gmail.com

1982


What is logical data model?

898


How can bottlenecks be identified?

785


What are different table types used in teradata?

816


What is smp and mpp platforms?

741


How to explain project Architecture and flow in teradata interviews?Can please anyone help on this? Am new to teradata.

4157


Can you connect multiload from ab initio?

935


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

826


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

922


What do you mean by ttu in teradata?

770


What is spool space?

841


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

797