Interested to Buy Any Domain ? << Click Here >> for more details...
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
What do you mean by ttu in teradata?
Why do you get spool space errors? How do trouble-shoot them?
What do you mean by teradata intelliflex?
What is the difference between global temporary tables and volatile temporary tables?
How is MLOAD Client System restarted after execution?
What are the different table types supported by teradata?
Comment whether bottleneck is an error or not.
If I wanted to run a TPump job only once per day - basically working on a file that is produced once per day - how would you set up the parameters for that sort of job ?
If a Node is busy what are the steps you can take to avoid ?
What are the frequently used data types in teradata?
Highlight the limitations of TPUMP Utility.
What are default access rights in teradata?
What are tpump utility limitations?
Write a program to show the parser component used in teradata?
What are the steps to create a data model?
