what is identity columns in teradata
- 2 Answers
- 8743 Views
- Wipro, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / 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 |
Answer / yuvaevergreen
Identity column is a system generated value. Used for row
uniqueness. If rows need to be unique, then ALWAYS option
should be used with NO CYCLE option. Separate DBC table
takes care of identity columns DBC.idcol.
| Is This Answer Correct ? | 1 Yes | 0 No |
What is the difference between correlated sub queries and inner queries?
Can you fastexport a field, which is primary key by putting equality on that key?
Explain the meaning of Amp?
what is the difference between filter and router transmissions
What are the different table types supported by teradata?
What is meant by a Channel Driver?
Why FLOAD does not support multiset tables??
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
Explain the parallel data extension in teradata?
What are tpump utility limitations?
What is the difference between SI and JI?
What are the steps to create a data model?
Teradata 
