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

If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?

1734


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

3901


Why does varchar occupy 2 extra bytes?

604


How can bottlenecks be identified?

571


Difference between stored procedure and macro?

677






What are the steps to create a data model?

596


How do you do backup and recovery in teradata?

540


What is the use of virtual processor connectivity in teradata?

563


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

535


Which is faster fastload or multiload?

593


What does sleep function does in fast load?

616


What is bteq utility in teradata?

567


Which is more efficient group by or distinct to find duplicates?

635


What are some commonly used bteq scripts?

563


Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong

622