Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity column in TD?
- 2 Answers
- 8063 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
Identity columns are system generated values. Generally
these columns are used for unique values. Some restrictions are
1. Only 1 column can be specified as identity column.
2. PPIs, Join indexes, hash indexes cannot have identity
columns as indexes.
3."Default" and "Always with cycle" option in identity
columns may result in duplicates.
| Is This Answer Correct ? | 3 Yes | 0 No |
What is the process to restart the multiload if it fails?
What is a sparse index?
Hi frnds...can any one help me regarding this que.. We have column in a table name it as C1 WHICH CONTAIN ALPHANUMERIC AND NUMERIC VALUES. C1 2A 2B 2V 2H 1 2 3 4 5 i want to retrive numeric values like 1,2,3,4,5 How we can get Plz let me know.Thanks in advance
one table have input no name 10 rao 20 siva 30 srinu 10 rao i want to ouput like this way no name 20 siva 30 srinu 10 rao how it posible in only sql server query?not oracle?
Why teradata is used?
Can we have an unconnected lkp to lookup a db2 record against a teradata record? Doesnt seem to work. I could be wrong
Can we collect statistics on table level?
If a Node is busy what are the steps you can take to avoid ?
Hello Frndz, I have a table named product as shown below: product_id product_name 1 AAA 1 BBB 1 CCC 2 PPP 2 QQQ 2 RRR Now my output should be: product_id product_name_1 product_name_2 product_name_3 1 AAA BBB CCC 2 PPP QQQ RRR
Why MLOAD needs Work Tables?
write lock is compatiable with which type of lock?
How do you verify a complicated sql?
Teradata 
