what is identity columns in teradata
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 are the available primary index types in teradata.
any one answer me how they can analyzing the project using data ware housing?
Where is teradata rdbms used?
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?
How can we build data marts from FSLDM. is there any standard approach for this?Is FSLDM supports place ?
What is the purpose of using case expression in teradata?
What are the various indexes in teradata? How to use them? Why are they preferred?
What is FILLER command in Teradata?
write lock is compatiable with which type of lock?
What is a three-tier data warehouse?
what is the difference between bpo and call centre?
If the query is NOT WRITTEN PROPERLY then what are the recommendations you can give to the developer ?