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
How to view every column and the columns contained in indexes in teradata?
Why are oltp database designs not generally a good idea for a data warehouse?
What are the string manipulation operators and functions associated with teradata?
Where is teradata rdbms used?
What exactly do you know about catching in teradata?
What is the command in bteq to check for session settings ?
When tpump is used instead of multiload?
Explain the parallel data extension in teradata?
What is collect statistics?
How do you do backup and recovery in teradata?
What are default access rights in teradata?
What are the different design perspectives used in teradata?
What is bteq utility in teradata?
What is inner join and outer join?
How is MLOAD Client System restarted after execution?
