Interested to Buy Any Domain ? << Click Here >> for more details...
what is identity columns in teradata
- 2 Answers
- 9421 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 are default access rights in teradata?
What is the purpose of joins in teradata and what are the available join types?
What are tpump utility limitations?
Explain the most common data types used in teradata?
How do you Generate Sequence in Teradata?
How to view every column and the columns contained in indexes in teradata?
If the PMON is not working then how do you identify and monitor all the processes, resources and sessions ?
What is spool space?
During the Display time, how is the sequence generated by Teradata?
How can we pass Variable in Bteq with out using shell script Is it possible or not If possible let me know how can we pass varaibale
What are the steps involved after the disk manager passes the request?
How is the teradata different from oracle?
Teradata 
