what is identity column in TD?

Answer Posted / surendra reddy duggireddy

Identity Columns generate a system-generated number for
every row as it is inserted
in the table. It is also knows as a DBS Generated Unique
Primary Index. Identity
Columns are used if you want to guarantee row uniqueness in
a table and they can
simplify the initial port from databases other than
Teradata. They are often used as the
Primary Index so they can guarantee even distribution. In
some cases they are utilized to
optimize and simplify the first port from another database
that uses generated keys.
Identity columns do NOT need to be part of the Primary
Index, but they are often used
for that purpose because they provide even data
distribution. The biggest rule is that
you can only specify one Identity Column per table



Example:
-------
Create Table Employee_Table
( Employee_No INTEGER
GENERATED ALWAYS AS IDENTITY
(START WITH 1 INCREMENT BY 5
MAXVALUE 1000000
NO CYCLE)
, Dept_No INTEGER
,First_Name CHAR(20)
,Last_Name CHAR(20)
,Salary DECIMAL (10,2)
) PRIMARY INDEX (Employee_No);

Is This Answer Correct ?    8 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Hi send me the Teradata dumps to my id rajeshanantha@yahoo.co.in Thanks Rajesh. A

3141


Explain teradata architecture in detail with a diagram.

848


What is meant by a dispatcher?

786


What does sleep function does in fast load?

843


What are the different softwares used with their functions in teradata?

787


how can we analyze the locks ?

1878


Highlight the advantages of PPI(Partition Primary Index).

794


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

1960


What is teradata? Also, list out some of the primary characteristics of teradata.

781


What are some commonly used bteq scripts?

761


What is the difference between fastload and multiload? Which one is faster?

886


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

1905


What are the various indexes in teradata?

778


What is the basic syntax for teradata select statement?

772


What is primary index and secondary index?

800